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

Resolved Assigning a DWO to a datastore causes app error (R0002)

  1. Issue
0
Votes
Undo
  1. Olan Knight
    Olan Knight
  2. PowerBuilder
  3. Thursday, 19 July 2018 20:51 PM UTC

PBv12.1 build 7055
Oracle 12C

What in the WORLD is going on here???????

Here's the code:
   lds_active = CREATE n_ds
   n_ds.DataObject = "d_fa_all_circuits_for_ban"    <--- this line fails
   ll_rc = lds_active.SetTransObject (sqlca)

 

When I hit the second line to assign the DataObject, I get this:

 

If I skip that line in DEBUG mode and manually add the string to the Datastore field in the object, it works perfectly.
This occurs when the object is both "n_ds" and "datastore".



Thanks,

Olan

Compute field in the trailer group
Datawindow: Best way to add a new group level in t...
Responses (3)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 19 July 2018 21:28 PM UTC
  2. PowerBuilder
  3. # 1

Well, poodlefarts and snrglemrfs!!!

I found the truly sill problem.

Change 

   n_ds.DataObject = "d_fa_all_circuits_for_ban"    

To

   lds_active.DataObject = "d_fa_all_circuits_for_ban"  


Wow, I feel schtoopid!  :O    

Thanks for your help!

 

Olan

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 19 July 2018 21:44 PM UTC
Excellent news Olan!



In these situations, I always find that MORE COFFEE helps - LOL!
  1. Helpful
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 19 July 2018 21:14 PM UTC
  2. PowerBuilder
  3. # 2

Thanks so much for your quick reply, Chris.

I tried all your suggestions, and so far...   :( 

1) Yes, the first line of the Edit Source for the new DWO is indeed "release 12;"
2) I've regenerated everything multiple times.
      Note that at first, selecting ALL of the objects in the PBL and regenerating them caused an error, however
      when I regenerated the objects one at a time, the regen succeeded.
3) At this time, the regen works on the new objects - the DWO and the function call in the NVO.
4) I exported the NVO, deleted it from the PBL, then re-imported the SRU file and regenned:  success

I've added the name of the new DWO to the PBR and am now doing a full build. Maybe that will help.
Also, I did not export, delete, and re-import the new DWO. Something to try after the full build.


Thanks Again,
Olan

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 19 July 2018 21:00 PM UTC
  2. PowerBuilder
  3. # 3

Hi Olan;

    I wonder if the DWO source is corrupted on not "up to par". If you edit the DWO source, does the 1st line read ...

release 12;

   Also, try regenerating the DWO & maybe even try an "optimize" on the DWO's PBL.

HTH

Regards ... Chris

 

Comment
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.