Cant add SIA Node on CCM

[Former Member]

Problem:

I am trying to install Crystal Server 2013. After installation, there was SIA created in CCM.

I tried to add SIA Node but got below error:

The root server reported an error Initialization Failure. (Reason: Database access error. Reason ORA-00904: "CMS_INCREMENTIDWITHROLLOVER7": invalid identifier .).

[rajdeep_marathe]

Hi,

Kindly give blank password for Administrator user while adding SIA.

Test and update me.

Regards,
Rajdeep

[Former Member]

Hi Fatai,

What was the message you got after the installation ?

Was the installation completed successfully? or it was completed with error ?

Do ensure that you followed all the pre-requisites as mentioned in KBA: 1952120 - SAP BusinessObjects (XI 3.1 and BI 4.0) Installation pre-requisites & best practices

Cheers,

Vibs

[Former Member]

I am facing the same issue, were you able to fix the issue. Could you please let us know how you were able to resolve it. Appreciate your response.

[yuvarajponnusamy]

Do u have any other server services running on the same port. Please check that too,if its there may be a port conflict.

[yuvarajponnusamy]

Fatai its sounds like you're connecting to a wrong CMS DB.Double check to where your SIA is pointed.

--

Yuvaraj

[yuvarajponnusamy]

Please confirm ur CMS DB is in local or remote DB?

Yuvaraj

[Former Member]

The CMS DB is on a remote server within my network.

[yuvarajponnusamy]

Hi Fatai,

Please check DB credentials,I think u dont have enough rights to create the CMS DB.

--

Yuvaraj

[Former Member]

Hi Yuvaraj,

I have sysdba access to CMS DB and all objects were created ok by the installation.

Cheers

[Former Member]

Check this KB- 1308716  - Database access error. Reason ORA-00904: "CMS_INCREMENTWITHROLLOVER5": invalid identifier...

[Former Member]

Thanks Jawahar but still the same issue.

There was no SIA installed on the CCM after my installation.

And when I tried to add SIA manually I get this error message.

I am using Oracle as my database.

[Former Member]

Hi Fatai,

Where is the error message that you get when you try to add a new SIA ?

-

Mihir

[Former Member]

Hi Mihr,

I am using the Node Wizard.

Got to final stage

Then adding node and it came to below message:

the log content:

The CMS has terminated unexpectedly with exit code 0.

ERROR: Could not establish a connection with any CMS.

ERROR: An unexpected internal error occurred. The CMS has terminated unexpectedly with exit code 0. (FWM 23025)

Help: Check the system event and CMS logs for indications on what may have caused the termination.