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

Resolved Cannot find the power builder logs

  1. How-to
0
Votes
Undo
  1. sharmistha sinha
    sharmistha sinha
  2. PowerBuilder
  3. Wednesday, 4 September 2019 08:26 AM UTC

Hello,

 

I am very new to powerbuilder. I have a screen to save/update Japanese characters in Database. (Sybase ASE)

But I get a DB error code 102. I want to check what is the exact query being run which throws this exception.

Where I can I find the PB logs for this?

I read that there is Pbtrace.log but I cannot find it.

please help.

 

TIA

Sharmistha

  1. PowerBuilder (Appeon)
pbc170.exe compilation
FileReadEX not working with large files (>300M)?
Accepted Answer
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Wednesday, 4 September 2019 09:08 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Sharmistha,

you have to enable the tracing.

In the IDE you can do that in the DB profile on "Connection" tab (option "Generate Trace")

If you want to trace SQL from your application you have to prepend "TRACE" in the DBMS property of the transaction object (e.g. SQLCA.DBMS = "TRACE O10").

Powerbuilder will ask you where to save the trace file.

HTH,

René

Comment
sharmistha sinha
  1. sharmistha sinha
  2. Wednesday, 4 September 2019 12:00 PM UTC
Hello, Thx for help. But I cannot see any connection tab in PB 2017. Can you please suggest where is it?
  1. Helpful
René Ullrich
  1. René Ullrich
  2. Wednesday, 4 September 2019 12:08 PM UTC
This is one possible way:

Menu Tools->Database Profiles

Select the profile you use for your database connection and press the "Edit" button.

It opens the Database Profile Setup dialog where you should find the "Generate Trace" option.

Save your change and connect (or reconnect) to the database. PowerBuild should ask you for the log file and what to log.



But remember: This setting is only for SQL that you run in the IDE!



  1. Helpful
There are no comments made yet.
Responses (2)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 4 September 2019 20:05 PM UTC
  2. PowerBuilder
  3. # 1

Sybase ASE Error 102 is:

Incorrect syntax near '*'.

 

In your app where it sets sqlca.DBMS to "ASE", change it to "TRACE ASE". When you run the app, it will prompt you for the log location.

 

Comment
sharmistha sinha
  1. sharmistha sinha
  2. Thursday, 5 September 2019 03:31 AM UTC
Thx!!
  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.