CORA Error Message:Cora not initialized yet!

[Leonio Alves]

Can someone help me?

 

This error happened after the migration from version 14.1 to 17.0:

 

mdb_registration_ 4340 ERROR mdb_registration.c 935 Unable to initial CORA API. RC: 470200
mdb_registration_ 4340 ERROR mdb_registration.c 937 CORA Error Message:Cora not initialized yet!
mdb_registration_ 4340 ERROR mdbreg.c 160 ca_reg_init failed (Cora not initialized yet!)
domsrvr 8264 ERROR factory.c 7803 Error in MDB_Registration_Handler method mdb_register_check: Cora not initialized yet!

[Paul Coccimiglio]

Lrralves 

When you run the PDM_STATUS command, do you see the mdb_registration_nxd process listed as started?

In the NX.ENV file, is the @NX_DB_NODE variable defined as the actual DB server host name or an alias?

[Leonio Alves]

When you run the PDM_STATUS command, do you see the mdb_registration_nxd process listed as started? yes, I do see.

In the NX.ENV file, is the @NX_DB_NODE variable defined as the actual DB server host name or an alias? hostname and instance (hostname\\instance)

[Alexander Perretti]

Also is there anything in the coraout log file located in the "bin" directory. It's possible you may get some hints in there.

[Leonio Alves]

Alex,

 

Follow log coraout. I did not understand why this error, this user has the same permissions in the approval and production environment. In the homologation environment works and in the production environment does not work.

 

18/10/16 13:26:05: [          10272] ERROR Cora.SqlSrvr                    - 47913680            SQLSRVR::logon [Microsoft SQL Server Native Client 11.0] [ SQL Code=18456 SQL State=28000] Login failed for user 'mdbadmin'. [sqlclass.cpp:128]

18/10/16 13:26:05: [          10272] ERROR Cora.SqlSrvr                    - 47913680            Throwing CCoraException((LONG) CORA_ERROR_CCORAMSS_INIT, (PCHAR)_datasource.GetLastErrorMsg())sqlclass.cpp/130 [sqlclass.cpp:130]

18/10/16 13:26:05: [          10272] ERROR Cora.SqlSrvr                    - 47913680            SQLSRVR::logon catching (...) [sqlclass.cpp:135]

18/10/16 13:26:05: [          10272] ERROR Cora.SqlSrvr                    - 47913680            SQLSRVR::logon throwing 470224 [sqlclass.cpp:136]

18/10/16 13:26:05: [          10272] ERROR Cora.SqlSrvr                    - 47913680            Throwing CCoraException((LONG) CORA_ERROR_CCORAMSS_INIT, (PCHAR)_datasource.GetLastErrorMsg())sqlclass.cpp/139 [sqlclass.cpp:139]

18/10/16 13:26:05: [          10272] ERROR Cora.CCoraMss                   - 47719792       CCoraMss::DbConnect catching cre [coramss.cpp:511]

18/10/16 13:26:05: [          10272] ERROR Cora.CCoraMss                   - 47719792       Throwing crecoramss.cpp/512 [coramss.cpp:512]

18/10/16 13:26:05: [          10272] ERROR Cora.CCoraApi                   - 10357448        ca_reg_initW catching cre [coraapi.cpp:1675]

 

[Paul Coccimiglio]

Lrralves ..........

Has the SDM server been restarted recently?  If not, please try restarting to see if it clears the error.

[Leonio Alves]

Yes, I recently restarted the SDM. I also ran coracleanup commands.

CORACLEANUP /SERVER <servername>  /TYPE 3 /USERNAME mdbadmin /PASSWORD <password> /SCOPE <scope> /METHOD reinit /INSTANCE <instance>

[Paul Coccimiglio]

Lrralves 

At this point, I think that a CA Support case is required for further investigation.

 

Enable the following tracing on the SDM Server where the error is occurring

 

pdm_logstat -f mdb_registration.c TRACE
pdm_logstat -f mdbreg.c TRACE
pdm_logstat -f sqlclass.c TRACE
pdm_logstat -f sql_agent.c TRACE
pdm_logstat -f factory.c TRACE

 

Reproduce the error then run the following to disable the tracing:

 

pdm_logstat -f mdb_registration.c
pdm_logstat -f mdbreg.c
pdm_logstat -f sqlclass.c
pdm_logstat -f sql_agent.c
pdm_logstat -f factory.c

 

When opening the CA Support case, provide the NX.ENV and .HIS files from the CA SDM server along with the NX_ROOT\log folder

[Raghu Rudraraju]

Leonio,

are you using a database cluster of some sort for this?

 

_R

[Leonio Alves]

Raghu,

 

The database is not clustered.

[Paul Coccimiglio]

Lrralves 

Please respond back to the earlier posts so we can assist you further.

[Leonio Alves]

Paul, 

 

Sorry, I replied the emails but they were not recorded here. Thanks for atencion.

[Leonio Alves]

I found the error. On the same SQL server, there was an instance using port 1433. Fixing this, the problem has been resolved. Thank you for attention.