Error on DBI

------_=_NextPart_001_01C65EE2.93D5E537
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I encountered this intermittent server error which I had been trying to
resolved :

*** 'd:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx' error
message at: 2006/04/12 21:08:23
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'DISP_MODFY_DT'. (SQL-S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=3D-1) at
d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99.
Unable to execute the SQL statement.=20
Affected Item: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
column name 'DISP_MODFY_DT'. (SQL-S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'DISP_MODFY_DT'. (SQL-S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=3D-1)=20

This is an SQL query. When I tried to run the query shown in the error
log, it works. The DB is Microsoft SQL 2000. May I know if anyone has
encountered this error and share with me what is wrong with the above?
I've tried debugging using DBI trace but its provide the same error
message as the server. I've also approached my DB administrator for
help, but it could be application problem. Is it the application problem
or DB problem?=20


------_=_NextPart_001_01C65EE2.93D5E537--

Re: Error on DBI

Your SQL statement in
d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99 contains
the column name "DISP_MODFY_DT" that does not exist in your database.
This is not a DBI problem, DBI is just reporting it. It is a problem
with your SQL statement, your Database and perhaps your connect string.

Alexander

On 13.04.2006 12:11, Raymond Wong wrote:

>Hi,
>
>I encountered this intermittent server error which I had been trying to
>resolved :
>
>*** 'd:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx' error
>message at: 2006/04/12 21:08:23
>DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL
>Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
>'DISP_MODFY_DT'. (SQL-S0022)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
>prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=-1) at
>d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99.
>Unable to execute the SQL statement.
> Affected Item: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
>column name 'DISP_MODFY_DT'. (SQL-S0022)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
>'DISP_MODFY_DT'. (SQL-S0022)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
>prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=-1)
>
>This is an SQL query. When I tried to run the query shown in the error
>log, it works. The DB is Microsoft SQL 2000. May I know if anyone has
>encountered this error and share with me what is wrong with the above?
>I've tried debugging using DBI trace but its provide the same error
>message as the server. I've also approached my DB administrator for
>help, but it could be application problem. Is it the application problem
>or DB problem?
>
>
>
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/

RE: Error on DBI

Hi Alexander,

Thanks for your reply. We have checked the table and DISP_MODFY_DT does
exist. In fact, when we re run the query using DBI or through query
analyzer, the query can return data. This is an intermittent problem
which makes the troubleshooting much more challenging. From your
experience, could this be a problem with DBI reporting false error? Or
could it be an intermittent problem over on the Database side? If that's
the case, could you send us an debug module so that we can capture more
clearly the state of the Database when this problem re-occurs?

Thanks a lot for your help.

-----Original Message-----
From: Alexander Foken [mailto:alexander@foken.de]=20
Sent: Thursday, April 13, 2006 6:29 PM
To: Raymond Wong
Cc: dbi-users@perl.org; Tricia Koh
Subject: Re: Error on DBI

Your SQL statement in
d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99 contains
the column name "DISP_MODFY_DT" that does not exist in your database.
This is not a DBI problem, DBI is just reporting it. It is a problem
with your SQL statement, your Database and perhaps your connect string.

Alexander

On 13.04.2006 12:11, Raymond Wong wrote:

>Hi,
>
>I encountered this intermittent server error which I had been trying to

>resolved :
>
>*** 'd:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx' error=20
>message at: 2006/04/12 21:08:23 DBD::ODBC::st execute failed:=20
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name=20
>'DISP_MODFY_DT'. (SQL-S0022) [Microsoft][ODBC SQL Server Driver][SQL=20
>Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022)=20
>[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not=20
>be prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=3D-1) at=20
>d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99.
>Unable to execute the SQL statement.=20
> Affected Item: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid=20
>column name 'DISP_MODFY_DT'. (SQL-S0022) [Microsoft][ODBC SQL Server=20
>Driver][SQL Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022)=20
>[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not=20
>be prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=3D-1)
>
>This is an SQL query. When I tried to run the query shown in the error=20
>log, it works. The DB is Microsoft SQL 2000. May I know if anyone has=20
>encountered this error and share with me what is wrong with the above?
>I've tried debugging using DBI trace but its provide the same error=20
>message as the server. I've also approached my DB administrator for=20
>help, but it could be application problem. Is it the application=20
>problem or DB problem?
>
>
> =20
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/

Re: Error on DBI

Do you use the same username and password to connect? Perhaps the DB
permissions do not allow the user account rpt_preview.plx uses to access
that column or table.

From my experience, DBI never falsely reports errors. The structure of
your error message ([vendor][driver][server]message) is typical for
ODBC, it is NOT generated by DBI.

Copy and paste the SQL statement from rpt_preview.plx into an SQL query
tool, and use the username and password from rpt_preview.plx to login.

Alexander


On 17.04.2006 05:11, Raymond Wong wrote:

>Hi Alexander,
>
>Thanks for your reply. We have checked the table and DISP_MODFY_DT does
>exist. In fact, when we re run the query using DBI or through query
>analyzer, the query can return data. This is an intermittent problem
>which makes the troubleshooting much more challenging. From your
>experience, could this be a problem with DBI reporting false error? Or
>could it be an intermittent problem over on the Database side? If that's
>the case, could you send us an debug module so that we can capture more
>clearly the state of the Database when this problem re-occurs?
>
>Thanks a lot for your help.
>
>-----Original Message-----
>From: Alexander Foken [mailto:alexander@foken.de]
>Sent: Thursday, April 13, 2006 6:29 PM
>To: Raymond Wong
>Cc: dbi-users@perl.org; Tricia Koh
>Subject: Re: Error on DBI
>
>Your SQL statement in
>d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99 contains
>the column name "DISP_MODFY_DT" that does not exist in your database.
>This is not a DBI problem, DBI is just reporting it. It is a problem
>with your SQL statement, your Database and perhaps your connect string.
>
>Alexander
>
>On 13.04.2006 12:11, Raymond Wong wrote:
>
>
>
>>Hi,
>>
>>I encountered this intermittent server error which I had been trying to
>>
>>
>
>
>
>>resolved :
>>
>>*** 'd:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx' error
>>message at: 2006/04/12 21:08:23 DBD::ODBC::st execute failed:
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
>>'DISP_MODFY_DT'. (SQL-S0022) [Microsoft][ODBC SQL Server Driver][SQL
>>Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not
>>be prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=-1) at
>>d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99.
>>Unable to execute the SQL statement.
>>Affected Item: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
>>column name 'DISP_MODFY_DT'. (SQL-S0022) [Microsoft][ODBC SQL Server
>>Driver][SQL Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not
>>be prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=-1)
>>
>>This is an SQL query. When I tried to run the query shown in the error
>>log, it works. The DB is Microsoft SQL 2000. May I know if anyone has
>>encountered this error and share with me what is wrong with the above?
>>I've tried debugging using DBI trace but its provide the same error
>>message as the server. I've also approached my DB administrator for
>>help, but it could be application problem. Is it the application
>>problem or DB problem?
>>
>>
>>
>>
>>
>>
>
>
>--
>Alexander Foken
>mailto:alexander@foken.de http://www.foken.de/alexander/
>
>
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/