1. Walther Rodirguez
  2. PowerServer
  3. Tuesday, 14 May 2024 15:45 PM UTC

I am getting an error when compiling in a DW with PB2023 R3

C:\SIGMNUEVO\Sigm\SIGM\OrdenServicio\sigm_ordenservicio_reportes.pbl|dw_ordenserviciodetalle_laboratorio_rpt Error: Invalid object name 'OrdenS.sys.all_objects'.

But in the DW code or in the store there is no reference to sys.all_objects

DW code attached

 

Attachments (2)
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 14 May 2024 17:56 PM UTC
  2. PowerServer
  3. # 1

My crystal ball went dark, so I am unable see your desktop. What DBMS and version are you using. and what PB database interface (SQLCA.DBMS = "???") are you using?

Comment
There are no comments made yet.
Walther Rodirguez Accepted Answer Pending Moderation
  1. Tuesday, 14 May 2024 18:13 PM UTC
  2. PowerServer
  3. # 2

PB2023 R2

Microsoft SQL Server 2019 (RTM-CU19) (KB5023049) - 15.0.4298.1 (X64)   Jan 27 2023 16:44:09   Copyright (C) 2019 Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: )

 

// Profile pf_operaciones
SQLCA.DBMS = "MSOLEDBSQL SQL Server"
SQLCA.LogPass = <**************************>
SQLCA.ServerName = "DES-SRVBD"
SQLCA.LogId = "adm_seguridad"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='BDOPERACIONES'"

 

PS DB Conf attached

 

 

Attachments (1)
Comment
  1. John Fauss
  2. Tuesday, 14 May 2024 18:33 PM UTC
Thank you for the info. Have you verified that the login/userid being used for the database connection has SELECT privileges for the sys.all_objects catalog view of the OrdenS database? An easy way to check is to connect to this database in the PB IDE using the same credentials, open the Database Painter, and execute the query "Select Count(*) From OrderS.sys.all_objects;" in the ISQL pane.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 14 May 2024 18:30 PM UTC
  2. PowerServer
  3. # 3

Hi Walther ;

  I see that this is a PowerServer question. Can you tell us ..

  • Does the DWO compile OK in the IDE on a "Regenerate" request?
  • Does this error only happen in a PowerServer build?
  • Is the PB IDE and PS DB connection pointing to the same DBMS Server & DB instance?

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.