Today, we have a problem that when we open k2 worklist with asp.net application. we got error message about "database error occured". So these are sample of error message on k2 log files.
on k2server.log:
30-01-08 16:57:07 K2.net Server Version 3.5140.1.0 (Service Pack 2a)
30-01-08 16:57:07 -------------------------------------------------
30-01-08 16:57:07 Server starting
30-01-08 16:57:07 Loading .NET Framework v1.1.4322
30-01-08 16:57:07 Framework loaded successfully
30-01-51 04:57:07 Service started under DOMAINserviceaccount
30-01-51 04:57:08 Sql initialized successfully
30-01-51 04:57:08 Server: (local), Database: K2
30-01-51 04:57:08 Socket initialized successfully
30-01-51 04:57:09 Worker initialized successfully
30-01-51 04:57:09 Evaluating License Key
30-01-51 04:57:09 K2.net Licensed for 1 CPU(s)
30-01-51 04:57:09 ThreadPool initialized successfully
30-01-51 04:57:09 Manager initialized successfully
30-01-51 04:57:09 Server running
30-01-51 04:57:16 Send Mail Open Job.Status: Completed
30-01-51 04:57:21 Send Mail Open Job.Status: Completed
30-01-51 04:57:25 Send Mail Open Job.Status: Completed
30-01-51 04:57:30 Send Mail Open Job.Status: Completed
30-01-51 04:57:30 Inform.SucRule: True
.....
.....
30-01-51 05:31:20 Authenticated DOMAINusername using NTLM
30-01-51 05:31:20 Marshalling: OpenWorklist2
30-01-51 05:31:40 A database error occured
30-01-51 05:38:23 Authenticated DOMAINusername using NTLM
30-01-51 05:38:23 Marshalling: OpenWorklist2
30-01-51 05:38:41 Authenticated DOMAINusername using NTLM
30-01-51 05:38:41 Marshalling: OpenWorklist2
30-01-51 05:38:43 A database error occured
on k2error.txt:
30-01-51 05:38:42 K2Sql.LoadProcess: Invalid attempt to read when no data is present.
at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetSqlInt32(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at K2Sql.LoadProcess(Process& Proc, Int32 ProcID)
30-01-51 05:38:42 K2Sql.OpenWorklist: A database error occured
at K2Sql.LoadProcess(Process& Proc, Int32 ProcID)
at K2Sql.GetProcess(Int32 proc)
at K2Sql.LoadWorklistFromReader(SqlDataReader dr, Boolean nodata)
at K2Sql.OpenWorklist(String user, String platform, Boolean nodata)
error message from web application custom error page:
On K2 service Manager can connect to k2server and can get worklist.
We use windows server 2003 Enterprise Edt. and sql server 2003 SP3 in the same machine (this is development server). And we use K2.net Licensed for 1 CPU(s).
In this case, we can start flow successfully but can not get worklist. In some k2 process, it can get worklist and start flow also.
So what is the problem? What are the solutions to solve the problem? Any idea?
Thanks much,
Arnondh C.
