Hi,
Good Day.
We need help regarding the issue we encountered when running our application in WEB
1. We have SET the AEM Data Source
2. Compiled the Application to WEB but when we run the application in Microsoft Edge Browser its not running and when we check the Appeon Error log it shows below logs:
--------------------
2018-03-27 18:07:57.233 : [Application name=XXXX,conn cache=SQLCA,SQLOrProcedure=select count ( * ) from pos_cash_recon_mast where convert ( date_format ( doc_date , '%Y/%m/%d' ) , char ( 10 ) ) <= convert ( date_format ( now ( ) , '%Y/%m/%d' ) , char ( 10 ) ) and comp_code = '01' and wh_id = 0 and status <> 'C']You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* ) from pos_cash_recon_mast where convert ( date_format ( doc_date , '%Y/%m/%d'' at line 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at Appeon.Server.Services.DataService.MySQL.EonMySQLCommand.ExecuteReader()
at Appeon.Server.Services.DataService.EonDbCommand.ExecuteSelectOne(SQLType sqlType, String sql)
at Appeon.Server.Commands.EmbedSQLCommand.ExecuteCommand()
2018-03-27 18:07:57.247 : [Application name=XXXX,conn cache=SQLCA,SQLOrProcedure=select max ( convert ( date_format ( doc_date , '%Y/%m/%d' ) , char ( 10 ) ) ) from pos_cash_recon_mast where convert ( date_format ( doc_date , '%Y/%m/%d' ) , char ( 10 ) ) <= convert ( date_format ( now ( ) , '%Y/%m/%d' ) , char ( 10 ) ) and comp_code = '01' and wh_id = 0 and status = 'C']FUNCTION ast_kpos.max does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at Appeon.Server.Services.DataService.MySQL.EonMySQLCommand.ExecuteReader()
at Appeon.Server.Services.DataService.EonDbCommand.ExecuteSelectOne(SQLType sqlType, String sql)
at Appeon.Server.Commands.EmbedSQLCommand.ExecuteCommand()
2018-03-27 18:07:57.276 : [Application name=XXXX,conn cache=SQLCA,SQLOrProcedure=select shift_code from pos_work_shift where convert ( cast ( now ( ) as char ( 20 ) ) , time ) between convert ( concat ( substring ( from_time , 1 , 2 ) , ':' , substring ( from_time , 3 , 2 ) ) , time ) and convert ( concat ( substring ( to_time , 1 , 2 ) , ':' , substring ( to_time , 3 , 2 ) ) , time )]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'char ( 20 ) ) , time ) between convert ( concat ( substring ( from_time , 1 , 2 ' at line 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at Appeon.Server.Services.DataService.MySQL.EonMySQLCommand.ExecuteReader()
at Appeon.Server.Services.DataService.EonDbCommand.ExecuteSelectOne(SQLType sqlType, String sql)
at Appeon.Server.Commands.EmbedSQLCommand.ExecuteCommand()
-------------------------------------
When we run our application in IDE there is no issue, but when we run in browser got the the above issue
Anyone has any idea what is wrong with the web configuration?
Your response and help will be highly appreciated.
Thank you.
Best Regards,
Rachelle
