1. Shayne Salsbury
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 22 April 2021 19:15 PM UTC

I am currently using PB 2019 R3 CloudPro Edition and trying to deploy an application to PowerServer (PB Edition).  I have deployed several simple applications with no issue.  I am now trying to deploy a more complex application and I am getting several entries log for SetTransObject.  

 

Code Diagnosis:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Unsupported Code:
Dw_1.SetTransObject(SQLCA)

Line Number:
4

Location:
Open() event/function of w_case_search in cp27.pbl


Unsupported Item:
Settransobject

Type:


Reason:
Can not found the function 'settransobject'

Priority:
Have to modify

 

The open event references DW_1 which is on the window

Open() event 

dw_1.SetTransObject( SQLCA )
dw_1.InsertRow( 0 )

Not sure what I am missing.  The documentation indicates that the SetTransObject function is supported.

 

Any help would be greatly appreciated.

Thanks,

Shayne Salsbury

Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Friday, 23 April 2021 02:35 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Shayne,

Is there any deploy error? This issue might be caused by that the transaction object 'SQLCA' is not supported. If your application uses a user object like 'n_tr' instead of a built-in system object that SQLCA inherits from, please make sure the object 'n_tr' has been deployed successfully and is not listed as unsupported.

If there is still the issue, please provide a simple PB case for us to reproduce it for more study, thanks.


Regards,
ZhaoKai

Comment
  1. Shayne Salsbury
  2. Wednesday, 28 April 2021 15:38 PM UTC
ZhaoKai,



I am working through a few deployment errors. I did not find anything in the deployment errors related to the transaction object but the SetTransObject issue has cleared. Not sure how I lost track of the deployment errors.



Thanks,

Shayne
  1. Helpful
  1. Kai Zhao @Appeon
  2. Thursday, 29 April 2021 02:33 AM UTC
Hi Shayne,



Glad to hear that the SetTransObject issue is cleared! If it occurred again, you can provide a simple PB case for us to reproduce the issue.



Regards,

ZhaoKai

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 22 April 2021 21:24 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Sample UFA report .... no SetTransObject() errors:

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 22 April 2021 20:55 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

Hi Shayne;

  Could it be that in your PowerServer "Application Profile" within the PB IDE's "PowerServer Toolkit" that you did not map SQLCA to a PowerServer DataSource? That is how PS resolves the SetTransObject() functionality at deployment & run time.

Regards ... Chris

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 22 April 2021 21:23 PM UTC
Hi Armeen ... I agree but, I have been doing PS Apps since 2008 and never got this message in the UFA. The only restriction is that SetTrans() command is NOT supported but, the SetTransObject() command IS supported.

I will post my current UFA next as an example from the current STD Framework's OrderEntry Demo App that uses "tons" of SetTransObject() commands.

Regards ... Chris

  1. Helpful
  1. Armeen Mazda @Appeon
  2. Thursday, 22 April 2021 22:25 PM UTC
It is very common for developers to forget to map the transaction object to connection cache, so if this was the cause we would be hearing about this erroneous unsupported feature from lots of users. I'll get one of the product engineers to help out on this.
  1. Helpful
  1. Shayne Salsbury
  2. Friday, 23 April 2021 02:31 AM UTC
The transaction object is defined in the application profile and does map to a local PowerServer datasource. I tested all of the connections as I setup the profile.



Thanks,

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