TEM 8.2 Console login issues

(imported topic written by Bhushan Chirmade)

Hello,

I am facing very strange issue. I have installed TEM 8.2.1093.0 evaluation version using express mode. Everything worked perfect initially including console login. Then I installed platform API 8.2.1093.0. Created a simple vbscript to create a test fixlet:

Dim username, password, dsn, privatekey

username = “EvaluationUser”

password = “ABC”

dsn = “bes_bfenterprise”

Set sk = CreateObject(“BESAPI.SigningKeys”)

sk.SetDefaultDSN(dsn)

'WScript.Echo sk.DiagnosticMessage

Set fc = CreateObject(“BESAPI.FixletCreator”)

fc.SetFixletType(“Fixlet”)

fc.SetName(“TestFixlet-BC1”)

fc.SetMessage(“This fixlet is relevant always”)

fc.SetRelevance(“true”)

fc.SetActionDescription(“Click here to deploy this action”)

fc.SetActionScript(“true”)

fc.SetActionTypeMIME(“application/x-fixlet-windows-shell”)

fc.SetCategory(“Miscellaneous”)

fc.SetDownloadSize(“0”)

Wscript.echo “Before propagation”

fc.DoPropagation username,password

Wscript.echo “After propagation”

If fc.fixletID = 0 Then

WScript.Echo "Error: " & fc.DiagnosticMessage

End If

When I ran this code I got following error message:

A database query unexpectedly returned too many results.

I was logged into console at this time. Once I closed my console I am not able to login anymore. I am continuously getting following error messages into filldb.log:

Thu, 29 Dec 2011 18:28:45 -0500 - 2484 - LicenseUpdater error: A database query unexpectedly returned too many results.

Thu, 29 Dec 2011 18:28:49 -0500 - 2480 - A database query unexpectedly returned too many results.

Thu, 29 Dec 2011 18:28:49 -0500 - 2480 - Disconnecting from database; will reconnect in 10 seconds.

Not sure what went wrong. I faced this issue 2 times. Please help to resolve this issue.

Regards,

Bhushan

(imported comment written by SystemAdmin)

A database query unexpectedly returned too many results -> I think this error pops up when the bes_bfenterprise dsn is pointing to the wrong database, like it’s set to use a default database of master instead of the BFEnterprise database.

(imported comment written by Bhushan Chirmade)

There was a old TEM client installed server which I was registering again which was causing some kind of loop condition in database. I tried without installing any client and it worked.

(imported comment written by Bhushan Chirmade)

Its the old client issue. I screwed up my system again. Opened PMR for the same issue. Started getting feeling that APIs are very scary to use with no rollback mechanism.

(imported comment written by Bhushan Chirmade)

I mean to say: Its not old client issue.