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

Resolved datawindow class not in PowerServer

  1. Issue
0
Votes
Undo
  1. Sang Chul Song
    Sang Chul Song
  2. PowerServer
  3. Friday, 1 July 2022 04:22 AM UTC

PowerBuilder Source

PowerServer Classes

pentahome use d_notice, but no class file in powerserver models.

why no datawindow class file?

 

PowerServer app run error

PowerServer 2021 Using non column in a stored proc...
How to use unicode characters on a powerserver clo...
Responses (3)
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Friday, 1 July 2022 09:30 AM UTC
  2. PowerServer
  3. # 1

Hi Sang,

Please try to delete the C# solution, then Build & Deploy PowerServer project in PB, then check the output to see whether there are some errors there.

Regards,

Logan

Comment
There are no comments made yet.
Sang Chul Song
Sang Chul Song Accepted Answer Pending Moderation
  1. Wednesday, 6 July 2022 00:31 AM UTC
  2. PowerServer
  3. # 2

error is table or view not found

 

easy sql

===========================

select distinct a.pgm_no as pgm_no,
a.pgm_id as pgm_id,
a.pgm_name as pgm_name,
a.parent_node as parent_node,
a.node as node,
a.sort_order as sort_order
from scm_user.pf_pgm_mst a
inner join scm_user.pf_user_pgm b
On a.pgm_no = B.PGM_NO
And b.emp_code = :as_empcode
where a.parent_node = '1'
and a.pgm_use_yn = 'Y'
and a.menu_use_yn = 'Y'

===========================

 

QERY TEST Success

 

Comment
Logan Liu @Appeon
  1. Logan Liu @Appeon
  2. Wednesday, 6 July 2022 04:58 AM UTC
Hi Sang,

Before you can build and deploy a PowerServer project, you MUST configure the database connection in the Database Configuration window (from the PowerServer project painter > Web APIs tab > Database Configuration button). Please verify it again.

Refer to: https://docs.appeon.com/ps2021/Configure_the_database_connection.html

Regards, Logan
  1. Helpful
There are no comments made yet.
Sang Chul Song
Sang Chul Song Accepted Answer Pending Moderation
  1. Wednesday, 6 July 2022 05:26 AM UTC
  2. PowerServer
  3. # 3

database configuration success

database profile same config

why "table & view not found" error message

Comment
Logan Liu @Appeon
  1. Logan Liu @Appeon
  2. Wednesday, 6 July 2022 08:22 AM UTC
Hi Sang,

PowerServer 2021 supports Oracle 12c, 18c, or 19c. Are you connecting to a supported Oracle version?

Refer to: https://docs.appeon.com/ps2021/Database_Server.html

Regards, Logan
  1. Helpful
Sang Chul Song
  1. Sang Chul Song
  2. Wednesday, 6 July 2022 09:22 AM UTC
Oracle 11g not support??

thank's for you're support
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 6 July 2022 15:59 PM UTC
No, only 12c and above. Oracle already EOL 11g. https://support.oracle.com/knowledge/Oracle%20Cloud/2068368_1.html
  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.