mobile application update faild with sql

1
0
-1

my connection in aem native mssql

 

when i update datawindow  from android mobile i got that

Conversion failed when converting date and/or time from character string

Question Tags: 

Answers

Chris Pollach answered mobile application update faild with sql

1
0
-1

Hi;

  I would suggest checking your AWS and PowerServer logs for more information into the failure. Check the PB & help for using AWS logging .

Regards ... Chris

intouch.intouch82_28534's picture

where can i found it in windows application i put that in sqlca.DBParm = "DateTimeFormat='#dd/mm/yyyy#'"

how can i put it in aem setting .

Govinda Lopez answered mobile application update faild with sql

1
0
-1

Hi intouch,

 

I would also recommend you to check the Connection properties and Data Source for that specific MS SQL connection. This is done in AEM too.

 

 

Regards,

intouch.intouch82_28534's picture

where can i found it in windows application i put that in sqlca.DBParm = "DateTimeFormat='#dd/mm/yyyy#'"

how can i put it in aem setting .

 

 

Govinda Lopez's picture

Hi intouch,

 

Only some DBParm parameters are supported by PowerServer. You can find out which ones here: https://www.appeon.com/support/documents/appeon_online_help/2017/features_help_for_appeon_mobile/ch09.html

 

I recommend you to place this parameter at the database level. Configuring MS SQL server properties for that database. You can find more info here: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-dateformat-transact-sql

‚Äč

I hope this helps.

 

Regards,