Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
Fernando_Goncal
Level 2

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

Replies

Avatar

Avatar
Validate 1
Level 1
Carlos_Nascimbe
Level 1

Likes

0 likes

Total Posts

39 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Carlos_Nascimbe
Level 1

Likes

0 likes

Total Posts

39 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Carlos_Nascimbe
Level 1

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

Avatar

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
Fernando_Goncal
Level 2

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

Avatar

Avatar
Validate 1
Level 1
Carlos_Nascimbe
Level 1

Likes

0 likes

Total Posts

39 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Carlos_Nascimbe
Level 1

Likes

0 likes

Total Posts

39 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Carlos_Nascimbe
Level 1

24-08-2010

Hi Fernando,

No problem!

What's the target enviroment?


The driver is indicated on the PreparetoInstall.pdf document.

Abrazo,

Carlos

Avatar

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
Fernando_Goncal
Level 2

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

Avatar

Avatar
Validate 1
Level 1
Carlos_Nascimbe
Level 1

Likes

0 likes

Total Posts

39 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Carlos_Nascimbe
Level 1

Likes

0 likes

Total Posts

39 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Carlos_Nascimbe
Level 1

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

Avatar

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
Fernando_Goncal
Level 2

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

Avatar

Avatar
Validate 1
Level 1
Carlos_Nascimbe
Level 1

Likes

0 likes

Total Posts

39 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Carlos_Nascimbe
Level 1

Likes

0 likes

Total Posts

39 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Carlos_Nascimbe
Level 1

25-08-2010

Hope so!

Abrazo

Avatar

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 2
Fernando_Goncal
Level 2

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
Fernando_Goncal
Level 2

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