Though, I recently had a referential integrity problem with a table in a different publication and All I got was a message that there is a problem with this table and the foreign key.... But I didn't know what record this is related to...
This happend on our production setup, I know I can modify the mobilink parameters for the service here and get more data , but since there are hundreds of people constantly syncing, It's really hard to start searching in the mobilink log file... also, I don't want to block the people who are succesfully syncing...
Knowing this, I tried to figure things out by debugging my application...I start a local server with following paramters in my application
So, I tried modifying the commandline parameters from for example -v+ to -vt ... But this wasn't allowed...
i finally resorted to comparing data of the remote database to the consolidated database manually.... and i found out the problem... unfortunately this took me more time than I liked...
Is there any possibility to get more details, preferably see the sql of the problem?
asked 10 Aug '15, 09:13
You can add a row to the ml_property table to change the log verbosity for specific remotes or users. See http://dcx.sap.com/index.html#sqla170/en/html/81c17f426ce21014857bd97eef7c5c52.html