This content has been marked as final. Show 6 replies
For some reason, the column "dUserTimeZone" appears twice in both the update and and the insert statement. This is causing the error.
Take a look at the structure of the database table "USERS" via SQL Developer or some other DB tool. Does this column actually exist twice? If so, how did that happen?
Yes, I noticed dUserTimeZone is present twice in the query. But the question is why + why log in via iis 6 works and via iis 7.5 I receive that error.
Of course in the database table there this column present only once.
no ideas...? :(
Lots of ideas, actually.
IIS 7 isn't the cause of the issue, it's just a red herring. The issue is the definition of the two queries "Uuser" and "Iuser". For some reason, there are duplicate fields being added to the query definition for these two queries.
IIS (or Apache, OHS, <insert any webserver here>) doesn't have any bearing on this - they aren't rewriting any Content Server queries. "Uuser" and "Iuser" are statically defined queries, contained in a htm file (query.htm) within the Content Server file structure. It should be a relatively simple task to verify the query definitions contained there. If the file is wrong, it's a bug. If that file appears correct, then search the Content Server file structure for "Uuser" and "Iuser". The likely culprit then is a customization/product extension that redefines these queries.
I tried searching for query.htm and found it in 2 locations:
find . -name query.htm
I made a backup of those query.htm files and then tried even deleting whole Uuser queries from there to see if then UCM will scream that something is wrong. Nothing happened. I tried this on the old servers where Microsoft Login works - I was able to login even after deleting Uuser query from both query.htm files.
Are really the queries defined in that query.htm file?
Yes, those particular queries are statically defined in a resource file. OOTB, it's query.htm. It sounds like, then, the definitions are still in another file, especially if you deleted the queries, restarted the system, and the system didn't complain.
Do a text find on 'Iuser' and 'Uuser'.