"ORA-00907: missing right parenthesis" when importing LCA files

[#1]

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

[#2]

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

[#3]

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

[#4]

Hi Fernando,

No problem!

What's the target enviroment?

The driver is indicated on the PreparetoInstall.pdf document.

Abrazo,

Carlos

[#5]

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

[#6]

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

[#7]

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

[#8]

Hope so!

Abrazo

[#9]

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