


Fernando_Goncal
Fernando_Goncal
24-08-2010
Import Applications via Adminui have caused an Oracle error that is preventing LCA import and remove tasks.
When users try to use "Home > Services > Applications and Services > Service Management", it causes the error
"ORA-00907: missing right parenthesis"
Environment detail:
Linux Red Hat
Websphere 7
Oracle 11g
Carlos_Nascimbe
Carlos_Nascimbe
24-08-2010
Hi Fernando,
I've already faced this issue on a LNX + WAS enviroment using Oracle as DB.
Please check that the correct JDBC driver is been used for your target APP Server and DB.
Regards,
Carlos
Fernando_Goncal
Fernando_Goncal
24-08-2010
Muitíssimo obrigado.
Estamos avançando um POC do LC Output na seguradora Porto Seguro para substituir o gerador de relatórios Jasper que é usado para gerar saída de varias aplicações.
O JDBC correto é o que está recomendado no Preapare to Install guide ES2 o é alguma Tech Note???
Fernando Goncalves
Solutions Engineer LC, Connect & Acrobat
Adobe Systems Brasil
Tel.: +55 11 2175-9595 ext. 1113
fegoncal@adobe.com
Carlos_Nascimbe
Carlos_Nascimbe
24-08-2010
Hi Fernando,
No problem!
What's the target enviroment?
The driver is indicated on the PreparetoInstall.pdf document.
Abrazo,
Carlos
Fernando_Goncal
Fernando_Goncal
24-08-2010
Client is getting the specific version of Linux Red Hat, JDK and Oracle JDBC driver.
DB is Oracle 11g and W.A.S is version 7
We did a turnkey install and Installer and Configuration Manager wizard did all the install, assembling EAR, and database bootstrap.
At the end of setup, Configuration Wizard validated the deployment successfully and also deployed the samples OK.
The problem only occurred when partner import the LCA of the POC application.
Fernando Goncalves
Solutions Engineer LC, Connect & Acrobat
Adobe Systems Brasil
Tel.: +55 11 2175-9595 ext. 1113
fegoncal@adobe.com
Carlos_Nascimbe
Carlos_Nascimbe
24-08-2010
Hi Fernando,
Very similar situation, the problem was solved using ojdbc5.jar from LC ES 2 installation media
The problem with this error its It will happen every time you try to import or export an LCA file from Workbench.
Hope this helps,
Carlos
Fernando_Goncal
Fernando_Goncal
25-08-2010
Hi Carlos
Thank you very much for the help.
It is going to help a lot to advance the POC.
Fernando Goncalves
Solutions Engineer LC, Connect & Acrobat
Adobe Systems Brasil
Tel.: +55 11 2175-9595 ext. 1113
fegoncal@adobe.com
Carlos_Nascimbe
Carlos_Nascimbe
25-08-2010
Hope so!
Abrazo
Fernando_Goncal
Fernando_Goncal
25-08-2010
I am expecting partner to test the workaround this afternoon and let you know if it solved.
Fernando Goncalves
Solutions Engineer LC, Connect & Acrobat
Adobe Systems Brasil
Tel.: +55 11 2175-9595 ext. 1113
fegoncal@adobe.com