Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Appeon Web error - MySQL connection issue

  1. Issue
0
Votes
Undo
  1. Rachelle Malimban
    Rachelle Malimban
  2. PowerBuilder
  3. Wednesday, 28 March 2018 02:14 AM UTC

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

 

  1. MySQL
  2. PowerServer Web
Problem with Powerscript Editor - no error message...
Slow Startup?
Responses (2)
Appeon Support Team
Appeon Support Team Accepted Answer Pending Moderation
  1. Thursday, 29 March 2018 06:21 AM UTC
  2. PowerBuilder
  3. # 1

Hi Rachelle,

Please try to resolve it with the following steps.

1. Go to the PowerServer Toolkit > Configure > DB Type Profile and double click ‘MySQL 5.X’.

2. Uncheck the option ‘Enclose table and column names in Quotes’ (checking this option is the potential cause of this issue).

3. Full deploy your application and test again.

Thanks,
ZhaoKai

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 28 March 2018 15:48 PM UTC
  2. PowerBuilder
  3. # 2

Hi Rachelle;

   Does the App work OK when run from the PB IDE with MySQL (ie: via ODBC)?

Regards ... Chris

 

Comment
Rachelle Malimban
  1. Rachelle Malimban
  2. Thursday, 29 March 2018 01:43 AM UTC
Hi Chris,



Thanks for the reply.



Yes, As i mentioned when we run the app in PB IDE via ODBC connection the application works OK.



Is there any configuration we missed out ?



Regards,



Rachelle

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.