Inspecting the results
Based on what is reported in Fiddler, you will get what is the
next step to take to debug failures in the application.
-
Result: 502
Result “502” means that Fiddler’s request for a web page was
blocked (or request delayed) by the site’s web server or firewall or
load balancer, causing the request to timeout. When it happens,
please check whether the connection from the current computer to
PowerServer is successful or not. -
Result: 404
Result “404” means that the requested item is not found. If it
occurs, please check whether the file exists on the web
server. -
Database related SqlCode and SqlErrorText
In the TextView of the requests, if you find an error with
SQLCode or SqlErrorText, it must be something wrong with the
database operations. In this case, please further check the relevant
code or .cs file behind the request, to see if there is something
wrong with the code or the .NET DataStore model (converted from the
PowerBuilder DataWindow), or the SnapObjects Runtime. -
Data retrieval
You can view the composition of the DataWindow that is
performing the data retrieval, and check for possible retrieval
errors.
-
Data type mappings
Pay attention to the data types used in the application or
returned by PowerServer when executing SyntaxFromSQL. If the data
type is different from what is specified in Data type mapping tables,
you may need to make the necessary adjustments to the model .cs
file, or possibly in the original SQL.