DB Designer failing to deploy projections

Hi

Normally this kind of issue occurs if you run any ddll,dml commands in between the database designer run.So will suggest you to kindly re-run DBD once again & make sure no other task should be performed in between.

Let me know if still faces any issues after re-running the same.

Regards

Rahul

Hi,

I tried the same on fresh install of the cluster with the same data and still have same error:

Database Designer started.

    For large databases a design session could take a long time; allow it to complete uninterrupted.
    Use Ctrl+C if you must cancel the session.

    Setting up design session...

    Examining table data...

    Loading queries from '/home/ec2-user/q'.
        Processed 7 SQL statement(s), all accepted and considered in the design.
    No existing projections found.


    Creating design and deploying projections...
        [100%] Analyzing data statistics...  Completed  of  .

        [100%] Optimizing query performance...  Completed  of  .

        [100%] Design in progress...  Completed  of  .

        [100%] Optimizing storage footprint...  Completed  of  .

        [100%] Generating deployment script...  Completed  of  .

    Query optimization results...ress...  

         Query 1 optimization ratio or status is 1
         Query 2 optimization ratio or status is 1
         Query 3 optimization ratio or status is 0.42
         Query 4 optimization ratio or status is 1
         Query 5 optimization ratio or status is 1
         Query 6 optimization ratio or status is 1
         Query 7 optimization ratio or status is FULLY OPTIMIZED BY EXISTING PROJECTIONS


Deploying and generating deployment script...
        [ 18%] Deploying/Dropping projections...  Completed 2 of 11 projections.

    Completed 2 of 11 projections.


 WARNING: Count mismatch. Some tables/projections could have been dropped by user before deployment or while deploying 

Design script is located in /home/ec2-user/designer/admp_design.sql
 Deployment script is located in /home/ec2-user/designer/admp_deploy.sql

Database Designer finished.
Press <Enter> to return to the Administration Tools menu.

Hi

Can kindly provide the output of below query:

=> Select design_phase,event_time,phase_complete_percent,phase_step from design_status order by event_time desc;

Also I would suggest you drop dbd workspace & re-run it again:

=> dbd_drop_all_workspaces('<DESIGNER>');

Also please keep the system idle and don't run anything while performing this operation.

Regards

Rahul

 That was not a very intuitive error messege hehehehehe