Databse Error: in Datawindow object - PB 8.0

In PB 8.0 I am adding a column to a data window consisting of 3 retrieval arguments. I am not able to save the datawindow with the new column added. It says Database error: No detailed message. Please help it is very urgent.
Who is Participating?
berXpertConnect With a Mentor Commented:

I got the same error on Sybase when you work with a temporary table, those named begining with #.

In Pb 6.5 you can create a temporary table, build a datawindow, save it, open it, change it and every thing is OK

In Pb 8.0 there is a reported bug where you can only create a new datawindow based on a temporary table and save it, but if you open it and try to change like add a column it does not save and send the message " Database error: No detailed message "

So I guess your table "V_STATUS" is accting like sybase's #temp_tables

To solve your problem you have to options:

A. build a new datawindow with your new query every time you change it. Bad thing is you need to reformat your DW


B. export your datawindow and edit its source code, there you can work on your query. Next just import it and your dw will have your new fields keeping its format. Bad thing is more dificult to work on source code than in painter.

Do you use the designer painter or you are writing the SQL directly?
Wath is the data type of the column the you are adding to the DW?
Please tell me more detail.
georgeroAuthor Commented:
I was using the SQL directly. The following is my SQL. It looks like the In-line view v_status in the query is a problem. Do you know, how can we get around it? It was working fine with 6.5 not in 8

 "PRD_ACCT_CMP_GRP"."COMPONENT_GRP_VAL" as phone_number,
 "PRD_ACCT_CMP_GRP"."COMPONENT_GRP_VAL" as home_800_number,
 "PRD_ACCT_CMP_GRP"."COMPONENT_GRP_VAL" as default_number,
 DECODE(:view_pin, 'Y', "PRD_ACCT_CMP_GRP"."COMPONENT_GRP_VAL", SUBSTR("PRD_ACCT_CMP_GRP"."COMPONENT_GRP_VAL", 1, 10)||'****') as calling_card_number,
'N' as TPV_stage_ind
 (SELECT product_account_id, occurrence_number,
             DECODE(SUM(DECODE(SIGN(NVL(bill_eff_end_date, to_date('12/31/4444','MM/DD/YYYY'))-sysdate), 1, 1, 0)),
               0, 'DISCONNECT', decode(sum(decode(sign(bill_eff_bgn_date - NVL(bill_eff_end_date,to_date('12/31/4444','MM/DD/YYYY')) ), 0,0,1)),0,'DISCON PEND','ACTIVE')) status,
             DECODE(SUM(DECODE(SIGN(NVL(bill_eff_end_date, to_date('12/31/4444','MM/DD/YYYY'))-sysdate), 1, 1, 0)),
              0, MAX(bill_eff_end_date), MAX(bill_eff_bgn_date)) status_date
             FROM        prd_acct_cmp
            WHERE product_account_id IN             (SELECT product_account_id      
                               FROM product_acct
                               WHERE customer_acct_id =:customer_acct_id)
                                GROUP BY product_account_id, occurrence_number) "V_STATUS"
Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

What kind of database are you using? I can't execute ."PRODUCT_ID"(*).
You can try to create the view in permanent mode in your db and refer to it directly in the where clause without the SQL that generate the view.
georgeroAuthor Commented:
I am unsing Oracle. I cannot create the view in permanent mode 'cos the view is going to vary based on the customer acct id I have in GUI. Also, many users might be accessing the view concurrently. That again is going to be a problem.
Then you can try to create a stored procedure that create the view and after execute the query. In the DW you must only call the stored procedure with the appropriate parameter
Which col are you trying to add ??
And does your current SQL works fine ??

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.