Service Desk Practitioners Forum
cancel

Check relations error in the log

Highlighted
Dantist
Trusted Contributor.

Check relations error in the log

hello all!
in the logserver.txt i found following:

25/04/2006 15:06:12 Query Builder can not join tables 624623633 and 602996740.

Check relations between itsm_members on one hand, and itsm_persons and itsm_persons on the other.

what is it ?
how resolve it ?

3 REPLIES
Saurabh Dubey
Acclaimed Contributor.

Re: Check relations error in the log

Hi Dantist,

You can try to run the command

sd_dbconfwizard.bat -CHECKSTRUCTURE

to check the DB for inconsistancies.

This error pertains to the joining of tables, you may have deleted a middle reference object somewhere, which may cause this error.

Hope this helps....
Regards,

Saurabh
Modesty is good!! But remember, all your life other people will try and take your achievements away from you, don't make it easy for them.
Dantist
Trusted Contributor.

Re: Check relations error in the log

i have start the check db there is log:

Checking database structure in console mode.
Changing the session dateformat to:mdy
Changing the session dateformat to:mdy
Database name:Microsoft SQL Server
Database version:8.0.2162
JDBC drivername:i-net OPTA 2000
JDBC driverversion:1.05(4.17)
datauser:sd
repouser:sd
database:sbi:1433
dbtype :SQL Server
Initializing.
SQLDialect: SQLServer
DatabaseServer:serv1
DatabasePort:1433
DatabaseInstance:
Connections to datastore :sd successfully opened
Connections to repository:sd successfully opened
Initializing InfoManager
Initializing DataMappingModel
Class version:4.5.0588.1805
Fetching ObjectModel
Database version:4.5.0588.1805
Checking messages(rep_messages)
Checking messages(rep_messages_locale)
Checking labels(rep_labels)
Checking labels(rep_labels_locale)
Checking entities
Checking attributes
Checking cartridges
Checking tables
Checking tables not in object model
Checking obsolete attributes
Finished.
Finished checking database structure.
Exit


it's ok ?
Saurabh Dubey
Acclaimed Contributor.

Re: Check relations error in the log

Hi dantist,

The DB is ok. Is the error getting repeated?? Let me check what these numbers refer to...

Regards,

Saurabh
Modesty is good!! But remember, all your life other people will try and take your achievements away from you, don't make it easy for them.