"Sorry! Something seems to be wrong at the moment"

[Frank]

Hi,

I've receive the following error when I click "Open Case" (logged in
as admin):

Sorry! Something seems to be wrong at the moment
For some lame reason things are not working the way they should.

Error Message: Problems executing sql statement: SELECT [value],
[label] FROM LookupValues WHERE IDLookupTable=1 with connection:
server=.\sqlexpress;database=Sinergia;Integrated Security=true

I've installed the app on the local IIS (OS: WinXP - SP2) and the
backend is hosted on an other machine (both db are grouped in one)
running a SQL Server 2005 Professional (OS: WinXP - SP2).

I've changed all known parameters for the DB-Server ConnStrings in the
WebApp-Config and the Workflow-Config.

When I execute the ...setup.aspx page and press all buttons I get an
"OK".

What have I also to do?

Thanks in advance,
Frank

[Gabriel Lopez]

Are there any logged errors in the Event Log?

thanks,
gabo

[Frank]

Hi Gabriel,

the EventLog shows the same error (partial on German):
...
Ausnahmeinformationen:
Ausnahmetyp: SinergiaSqlEnumerationException
Ausnahmemeldung: Problems executing sql statement: SELECT [value],

[label]
FROM LookupValues
WHERE IDLookupTable=1 with connection: server=.
\sqlexpress;database=Sinergia;Integrated Security=true

...
Threadinformationen:
Thread-ID: 1
Threadkontoname: APOLLO\ASPNET
Identitätswechsel für: False
Stapelüberwachung: bei
Sinergia.Logic.AdministrationManager.ListEnumerationValues(CustomEnumeration
enumeration) in D:\Develop\net\Tiger\Sinergia\src\Projects\Logic
\AdministrationManager.cs:Zeile 99.
bei
Sinergia.Logic.AdministrationManager.ListEnumerationValues(CaseFieldType
field) in D:\Develop\net\Tiger\Sinergia\src\Projects\Logic
\AdministrationManager.cs:Zeile 57.
bei Ticket_Management_Sample_1.InitCustomControls() in c:\Inetpub
\wwwroot\Sinergia\Web\restricted\controls\generated
\Ticket_Management_Sample_1.ascx.cs:Zeile 56.
bei Ticket_Management_Sample_1.Page_Load(Object sender, EventArgs
e) in c:\Inetpub\wwwroot\Sinergia\Web\restricted\controls\generated
\Ticket_Management_Sample_1.ascx.cs:Zeile 34.
bei System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object o, Object t, EventArgs e)
bei System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object
sender, EventArgs e)
bei System.Web.UI.Control.OnLoad(EventArgs e)
bei System.Web.UI.Control.LoadRecursive()
bei System.Web.UI.Control.LoadRecursive()
bei System.Web.UI.Control.LoadRecursive()
bei System.Web.UI.Control.LoadRecursive()
bei System.Web.UI.Control.LoadRecursive()
bei System.Web.UI.Control.LoadRecursive()
bei System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
...

greetings,
Frank

[PramodSingh]

I got the same error, I figured out that this error is due to the
database entry not matching with the SQL Server database.

The changes that I made in the database table is make the "actual"
database entry, steps to do are
1> Go to the Sinergia database
2>Open the table CustomEnumerations
3>Change the Row 2 with value IDCustomEnumeration value is 2 and
Expression value is server=.\sqlexpress;database=Sinergia;Integrated
Security=true|SELECT [value],[label]
FROM LookupValues
WHERE IDLookupTable=1
4> Chage the database name to the "actual" SQL Server database name

5> Run the application and you should not get this error.

Thanks,
Pramod

On Jul 10, 11:34 am, Frank <EifelFr...@gmail.com> wrote:
> Hi Gabriel,
>
> the EventLog shows the same error (partial on German):
> ...
> Ausnahmeinformationen:
> Ausnahmetyp: SinergiaSqlEnumerationException
> Ausnahmemeldung: Problems executing sql statement: SELECT [value],
> [label]
> FROM LookupValues
> WHERE IDLookupTable=1 with connection: server=.
> \sqlexpress;database=Sinergia;Integrated Security=true
> ...
> Threadinformationen:
> Thread-ID: 1
> Threadkontoname: APOLLO\ASPNET
> Identitätswechsel für: False
> Stapelüberwachung: bei

> Sinergia.Logic.AdministrationManager.ListEnumerationValues(CustomEnumeratio­n

[Frank]

That's it.
Thanks a lot, Pramod.

greetings,
Frank