Parse failed: exception: dbd, ora 00903: invalid table name state N/A

[Former Member]

Gurus,

We have a SAP BOBJ 3.1 Universe based on Oracle. After adding all the tables, and creating the necessary joins and after performing the Integrity check, I get a "Parse failed: exception: dbd, ora 00903: invalid table name state N/A" for 3 objects. When I checked these objects by clicking on the 'Tables' button, all these objects have been assigned to their corresponding tables. Could you please help me resolve this issue?

Points will be awarded. Many thanks for your time.

Regards,

G.

[former_member193452 · Accepted solution]

Hi G,

You can try renaming table owner/qualifier and use all caps.

1. Right-click on the table in the Structure view and select "Rename Table".

2. In the "Owner:" box, enter the correct table owner name or use CAPITALS.

3. Click OK

Or

You can try creating an ALIAS to that table and re-pointing the objects to the ALIAS.

J.

[former_member193452 · Accepted solution]

Also,

You can check this...make sure you are on an updated patch level (patch 6 is avaible.)

Check your oracle.prm file for the following parameter.

To locate the correct prm file for your environment:

launch designer and import your universe.

Go to File/parameters and click the test button on the bottom right of the general tab.

When server is responding message appears! Click the Details button.

Scroll down to the prm line.  Arrow over to the end.  This will tell you the correct path for your environment.

copy the file as a backup.

Close universe designer

Open the original prm file in notepad and check for this parameter:

<Parameter Name="IDENTIFIER_DELIMITER">&quot;</Parameter>

If it does not exist, then add it to the top paragraph.

save and close the prm

Restart the universe designer and check for parsing.

[Former Member · Accepted solution]

Sorry for the delayed response. I created an Alias and it resolved the issue.

Thanks,

G.