DBManager::disconnect() for MSSQL

[Shraddha]

Hi,
Version: SugarCRM 6.0.3 using WAMP and MSSQL 2005

I am currently trying to list all users bellow ACLRoles Detail View in subpanel
but get the following error in log file:

Query:SELECT users_company_role.*, acl_roles.* FROM acl_roles
INNER JOIN users_company_role ON users_company_role.user_id = '1'
AND users_company_role.role_id = acl_roles.id AND users_company_role.deleted = 0 WHERE acl_roles.deleted=0

01/19/12 13:51:15 [5884][1][INFO]
Query Execution Time:0.00027704238891602
01/19/12 13:51:22 [5884][1][DEBUG] Hook called: ::server_round_trip

01/19/12 13:51:22 [5884][1][DEBUG] Including generic hook file
01/19/12 13:51:22
[5884][1][DEBUG] Calling DBManager::disconnect()


If I'm showing less than 18 records then the records are correctly listed (the error is shown after the first 18 are listed) but if there are more than 18 then the remaining records aren't listed.It shows blank page.

The sugarlog (with debugs) around the error is:
Query:SELECT users_company_role.*, acl_roles.* FROM acl_roles
INNER JOIN users_company_role ON users_company_role.user_id = '1'
AND users_company_role.role_id = acl_roles.id AND users_company_role.deleted = 0 WHERE acl_roles.deleted=0

01/19/12 13:51:15 [5884][1][INFO]
Query Execution Time:0.00027704238891602
01/19/12 13:51:22 [5884][1][DEBUG] Hook called: ::server_round_trip

01/19/12 13:51:22 [5884][1][DEBUG] Including generic hook file
01/19/12 13:51:22
[5884][1][DEBUG] Calling DBManager::disconnect()

We also have an identical SugarCRM instance on a different server that uses mssql 2005. On this instance the listing works without errors.

if anyone has had any luck with listing using 6.0.3 and mssql?

Note:
I have tried with the solution in forum titled "Importing fails when using MSSql"
i.e
add this line:
if ( !isset($monitor->seconds) ) $monitor->seconds = 1;

after line
if ( !isset($monitor->active) ) $monitor->active= 1;

in file modules\Trackers\store\TrackerSessionsDatabaseStor e.php

But still its not working

[jmertic]

Hi,
Version: SugarCRM 6.0.3 using WAMP and MSSQL 2005

I am currently trying to list all users bellow ACLRoles Detail View in subpanel
but get the following error in log file:

Query:SELECT users_company_role.*, acl_roles.* FROM acl_roles
INNER JOIN users_company_role ON users_company_role.user_id = '1'
AND users_company_role.role_id = acl_roles.id AND users_company_role.deleted = 0 WHERE acl_roles.deleted=0

01/19/12 13:51:15 [5884][1][INFO]
Query Execution Time:0.00027704238891602
01/19/12 13:51:22 [5884][1][DEBUG] Hook called: ::server_round_trip

01/19/12 13:51:22 [5884][1][DEBUG] Including generic hook file
01/19/12 13:51:22
[5884][1][DEBUG] Calling DBManager::disconnect()


If I'm showing less than 18 records then the records are correctly listed (the error is shown after the first 18 are listed) but if there are more than 18 then the remaining records aren't listed.It shows blank page.

The sugarlog (with debugs) around the error is:
Query:SELECT users_company_role.*, acl_roles.* FROM acl_roles
INNER JOIN users_company_role ON users_company_role.user_id = '1'
AND users_company_role.role_id = acl_roles.id AND users_company_role.deleted = 0 WHERE acl_roles.deleted=0

01/19/12 13:51:15 [5884][1][INFO]
Query Execution Time:0.00027704238891602
01/19/12 13:51:22 [5884][1][DEBUG] Hook called: ::server_round_trip

01/19/12 13:51:22 [5884][1][DEBUG] Including generic hook file
01/19/12 13:51:22
[5884][1][DEBUG] Calling DBManager::disconnect()

We also have an identical SugarCRM instance on a different server that uses mssql 2005. On this instance the listing works without errors.

if anyone has had any luck with listing using 6.0.3 and mssql?

Note:
I have tried with the solution in forum titled "Importing fails when using MSSql"
i.e
add this line:
if ( !isset($monitor->seconds) ) $monitor->seconds = 1;

after line
if ( !isset($monitor->active) ) $monitor->active= 1;

in file modules\Trackers\store\TrackerSessionsDatabaseStor e.php

But still its not working

I would try upgrading to 6.3 or 6.4 when it goes GA. as they both have much better SQL Server support than 6.0.3