Information Manager Data Direct PDL data
I have one 800XA system, with batch option.
I have one report in excel using data direct PDL option to retrieve batch information.
until last month this report was working fine.
but now report is not working, when i try to open PDL access in excel appears the message :
"PDL access not available in the server"
I see oracle database and it seems ok.
I checked for windows services and almost all are ok, but there is one service Oracle Dbconsole ADVA that is not running and is it not possible to put in run state.
please check Service_error image.
Someone has any idea what could be the problem?
I was able to provoke the same error in my lab by intentionally stopping the ADSS ADO data provider (the provider that provides Oracle access to DataDirect).
I suggest that you fault trace ADSS; the Application log of Windows is commonly used by ADSS - look for event with source = "ADS".
Maybe you have a resource problem kicking the ADO provider (ADSdpADO.exe) off its feet? Can you see it in the V$SESSION table (a table containing all clients currently logged into Oracle) by executing the following SQL statement: "SELECT program FROM v$session"?
Can you login to Oracle at all? ("sqlplus /" or "sqlplus /@localhost")?
If you know your SQL, you can use Section 9 - Reading Message Logs of the IM Data Access and Reports User's Guide (3BUF001094-510) to post manual SQL queries towards the database to verify that your PDL log exists and collects data as it should.
Anyway I believe it to be advisable to contact your regional ABB support center and ask them to assist you.