I am not sure how to view the query sent to MSSQL. Here's a little more
from the error record:
-
*File C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py in
insert at line 539* code arguments variables
Function argument list
(self=<pydal.adapters.mssql.MSSQL4 object>, table=<Table
web2py_session_PubView (id, locked, clien...me, modified_datetime,
unique_key, session_data)>, fields=[(<pydal.objects.Field object>,
'172.20.145.208'), (<pydal.objects.Field object>, 0), (<pydal.objects.Field
object>, '2020-06-03T00:26:05.296000'), (<pydal.objects.Field object>,
'affc9c47-0085-45dc-8352-12549c7f93dc'), (<pydal.objects.Field object>,
datetime.datetime(2020, 6, 3, 0, 26, 5, 296000)), (<pydal.objects.Field
object>,
'\x80\x02cgluon.globals\nSession\nq\x01}q\x02U\x05flashq\x03U\x00s\x85Rq\x04.')])
Code listing
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
self.execute(query)
except:
e = sys.exc_info()[1]
if hasattr(table, "_on_insert_error"):
return table._on_insert_error(table, fields, e)
raise e
if hasattr(table, "_primarykey"):
pkdict = dict(
[(k[0].name, k[1]) for k in fields if k[0].name in
table._primarykey]
)
Variables
e DataError('22007', '[22007] [Microsoft][ODBC SQL...e from character
string. (241) (SQLExecDirectW)')
Context
On Wednesday, June 3, 2020 at 9:14:15 AM UTC-4, Jim S wrote:
>
> Can you pinpoint the line in your code that is causing the error?
>
> Can you see the SQL statement that is being sent to the server?
>
> -Jim
>
> On Tuesday, June 2, 2020 at 11:29:27 PM UTC-5, Seth J wrote:
>>
>> Yes, same error. 🤷🏼♂️
>>
>> Error ticket for "PubView"Ticket ID
>>
>> 172.20.145.208.2020-06-03.00-26-05.a903caa0-1d7d-4612-a5f9-104967995098
>> Version
>> web2py™ Version 2.20.4-stable+timestamp.2020.05.03.05.18.50
>> Python Python 2.7.10: C:\Python27\python.exe (prefix: C:\Python27)
>> Traceback
>>
>> 1.
>> 2.
>> 3.
>> 4.
>> 5.
>> 6.
>> 7.
>> 8.
>> 9.
>> 10.
>> 11.
>>
>> Traceback (most recent call last):
>> File ".\gluon\main.py", line 456, in wsgibase
>> session._try_store_in_db(request, response)
>> File ".\gluon\globals.py", line 1254, in _try_store_in_db
>> record_id = table.insert(**dd)
>> File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\objects.py", line 888,
>> in insert
>> ret = self._db._adapter.insert(self, row.op_values())
>> File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line
>> 539, in insert
>> raise e
>> DataError: ('22007', '[22007] [Microsoft][ODBC SQL Server Driver][SQL
>> Server]Conversion failed when converting date and/or time from character
>> string. (241) (SQLExecDirectW)')
>>
>> Error snapshot [image: help]
>> <https://vmweb2pysql02.gpo.gov/admin/default/ticket/PubView/172.20.145.208.2020-06-03.00-26-05.a903caa0-1d7d-4612-a5f9-104967995098#>
>>
>> <class 'pyodbc.DataError'>(('22007', '[22007] [Microsoft][ODBC SQL Server
>> Driver][SQL Server]Conversion failed when converting date and/or time from
>> character string. (241) (SQLExecDirectW)'))
>>
>> On Tuesday, June 2, 2020 at 1:53:37 AM UTC-4, Clemens wrote:
>>>
>>> Have you already tried the latest version
>>> 2.20.4-stable+timestamp.2020.05.03.05.18.50
>>> <http://www.web2py.com/init/default/download>?
>>>
>>>
>>> On Monday, June 1, 2020 at 8:12:08 PM UTC+2, Seth J wrote:
>>>>
>>>> I am running IIS connecting to SQL Server. Upgrade seems to have
>>>> introduced an error to an otherwise functioning app. Any ideas???
>>>>
>>>> [image: error_web2py.png]
>>>>
>>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/5742bfe1-e0ae-4dc8-9455-21a1098572f1%40googlegroups.com.
