cancel
Showing results for 
Search instead for 
Did you mean: 

Empty folders for Sybase power Designer Metadata in Metadata Management

venkataramana_paidi
Contributor
0 Kudos

Hi ,

I Have created Integrator source connection for  Sybase Power Designer in CMC. I have seen three folders in the Information steward metadata management .  Those are Change Lists,Closed Changed Lists, Library

If I  click on any folder  inside there is no information .

But I  have already check in the models to the Sybase Power Designer repository .

Thanks & Regards,

Ramana.

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hi Ramana,

Has this issue been solved?  We're struggling with a similar issue with replicating PD models to IS.  Replication works fine when de PD repository does not contain any model, but as soon as one entity or table is added to a model, the replication hangs. The issue has been reported 4 weeks ago by SAP with high priority but no response.

The three empty folders desribed by you appear in IS.

The issue is described in: http://scn.sap.com/message/15193814#15193814

Thanks

Gijsbert

Former Member
0 Kudos

I need to see your log to figure out why the model isn't collected.  You should see EMP_DB.

venkataramana_paidi
Contributor
0 Kudos

Hi Cheryl Ehlman,,

Please let me know which log files I have to check . Please tell me log file name to check .

I have checked the ICC.MetadataService_Venkata-PC_20140417_91243355_136_0.log file . Nothing is available related to connections etc.

Thanks & Regards,

Ramana.

Former Member
0 Kudos

Go to the PowerDesigner Integrator configuration and open the history page.  There is a line for each run that has completed.  Please go to the last line in the history page and press the download button on the right.  That is the log for the Power Designer collection.

venkataramana_paidi
Contributor
0 Kudos

Hi Cheryl Ehlman,

Please find the connection log details below.

[I] 2014-04-16 10:27:58.267 Information Steward version 14.2.1.220.

[I] 2014-04-16 10:27:58.278 Starting utility com.sap.mm.integrator.pd.PDIntegrator. (COR-10013)

[I] 2014-04-16 10:27:58.280 Process ID = 15628 on machine Venkata-PC.

[I] 2014-04-16 10:27:59.431 Connected to the Information Steward repository at jdbc:sqlserver://VENKATA-PC:1433;databaseName=IS_DB. (COR-10017)

[I] 2014-04-16 10:28:00.576 Started execution on 2014-04-16 10:27:58. (COR-10014)

[I] 2014-04-16 10:28:01.600 Utility processing starts.

[I] 2014-04-16 10:28:03.887 Collecting PowerDesigner metadata ... (PDM-10007)

[I] 2014-04-16 10:28:08.237 Collecting PowerDesigner glossary metadata ... (PDM-10065)

[I] 2014-04-16 10:28:09.767 Total number of type Glossary term to collect: 0. (PDM-10010)

[I] 2014-04-16 10:28:09.785 Total number of type Glossary category to collect: 0. (PDM-10010)

[I] 2014-04-16 10:28:10.580 Finished collecting PowerDesigner glossary metadata. (PDM-10066)

[I] 2014-04-16 10:28:10.608 Total number of type Physical Data Model to collect: 1. (PDM-10010)

[I] 2014-04-16 10:28:10.609 Total number of type Logical Model to collect: 0. (PDM-10010)

[I] 2014-04-16 10:28:10.635 Total number of type Conceptual Model to collect: 0. (PDM-10010)

[I] 2014-04-16 10:28:18.508 Physical Data Model collection progress: 1 of 1 completed. (PDM-10009)

[I] 2014-04-16 10:28:53.157 Glossary category collection complete. Total 0: 0 collected; 0 skipped; 0 deleted; 0 warnings; 0 errors; 0 bypassed. (PDM-10011)

[I] 2014-04-16 10:28:53.159 Conceptual Model collection complete. Total 0: 0 collected; 0 skipped; 0 deleted; 0 warnings; 0 errors; 0 bypassed. (PDM-10011)

[I] 2014-04-16 10:28:53.161 Logical Model collection complete. Total 0: 0 collected; 0 skipped; 0 deleted; 0 warnings; 0 errors; 0 bypassed. (PDM-10011)

[I] 2014-04-16 10:28:53.163 Physical Data Model collection complete. Total 1: 1 collected; 0 skipped; 0 deleted; 0 warnings; 0 errors; 0 bypassed. (PDM-10011)

[I] 2014-04-16 10:28:53.206 Glossary term collection complete. Total 0: 0 collected; 0 skipped; 0 deleted; 0 warnings; 0 errors; 0 bypassed. (PDM-10011)

[I] 2014-04-16 10:28:53.207 Finished collecting PowerDesigner metadata. (PDM-10008)

[I] 2014-04-16 10:29:01.095 Utility processing ended.

[I] 2014-04-16 10:29:01.478 Utility has completed successfully. (COR-10021)

[I] 2014-04-16 10:29:01.480 Completed execution on 2014-04-16 10:29:01. (COR-10015)

[I] 2014-04-16 10:29:01.482 Elapsed time is 1:03.272 [min:sec.millisec]. (COR-10084)

Thanks & Regards,

Ramana.

Former Member
0 Kudos

The log indicates it was collected.  Please logoff/logon to the Information Steward Explorer again and see if the model is listed.  If not, you'll need to contact support so someone can look at your system.  I can see on reason the model isn't being listed in the UI.

Former Member
0 Kudos

When you look in the Power Designer repository, where do you see the models you've checked into the repository.  Are they checked in under those folders?  (Change Lists, Closed Change Lists, and Library)?

If the models aren't under those folders, you won't see them listed under those folders in the Information Steward Explorer.

If you can see the models under the main page in the Information Steward explorer, they've been collected. 

venkataramana_paidi
Contributor
0 Kudos

Hi ,

I have created the change lists in Sybase power designer .

Please find the below screenshot of object browser/change lists  for reference.

But If I opened my Information Steward  power Designer metadata , there are blank folders including change list. Is any other settings I have to to do get the change lists  .  There are 2 change lists in the repository 1000,1002 but why it is not coming .

Please help me how to resolve this issue.

Thanks & Regards,

Ramana.

Former Member
0 Kudos

You don’t actually have models checked into a location we collect.  You have models in changelists, which are pending approval.  We can’t collect those.  We only collect models that are approved and in the repository.

I also wanted to point out that  you are working with conceptual data models.  The only models that we fully collect are physical data modes.  We only collect global information for conceptual and logical models.

venkataramana_paidi
Contributor
0 Kudos

Hi Cheryl Ehlman,

Thanks for your support .

This Time I have created the physical model. 

Please find the below screenshots step by step .

1. I have created the physical model using reverse engineering .

2. I have created one more user SUBMITTER along with ADMIN and gave permissions as "FULL"

3. I have log in with SUBMITTER and created the change list .

4.I have submitted for approval .

5. I have log in with ADMIN user to approve the change list .

6.   I have approved the change list  with using user ADMIN.

7. Once I approved  there is no change list in the repository.

8. I have logged into Information steward and checked the metadata management part . I can see the below thing .

When I checked the Change Lists , Closed Change Lists  and Library  folder were still empty.

Please suggest me how I can get the change list data in those folders.

Thanks & Regards,

Ramana.