Question
GalaxE.Solutions
US
Last activity: 4 Mar 2016 9:52 EST
Not able to see the generated DDL/Schema file from BIX Extract in the output directory
We are implementing BIX in our organization to extract some properties in CSV to our application server. We specified the path and tested the connectivity. It is good. When we run the extract, it is showing a success message and few records are extracted as well, but we are not able to see the extracted sql/manifest file in the local directory. I appreciate your help.
Accepted Solution
GalaxE.Solutions
US
Yes, Actually we were trying with DB schema. So, Generated DDL for that purpose. The issue is resolved now.
The reason for that issue is we were trying to extract the records from the Framework layer rather than the Implementation layer. Thanks for your help Celeste and Rajiv.
Pegasystems Inc.
US
I'm a little confused about what output format you are using. Are you extracting to CSV or DB? If you are extracting to CSV then the extracted file will be on the app server in the directory specified if running from the UI or if running from the command line it will be on the node you are running from. For a DB extract then obviously the output would be in the target DB. If you are generating the DDL then again will depend on if you are running from UI or command line on what node it will be on. If you post the PegaBIX log file the details should all be in there.
GalaxE.Solutions
US
Thanks Celeste Dufresne for the reply.
I am extracting to CSV and not able to find it on the app server. Then I tried with DDL generation, even I didn't find the sql file in the app server. And I am running the extract from Designer studio not the command line.
Attached is log file. I appreciate your help
Pegasystems Inc.
US
For your extract rule could you post a screenshot of the "File Specification" tab. For a csv extraction there is no DDL. That is only for a DB extraction. Are you generating a manifest and sending that to the database or have you just tried with csv and with db separately and just don't see the output file?
Updated: 3 Mar 2016 13:10 EST
GalaxE.Solutions
US
Yes, I have tried with csv and db separately. I could not get output for any of them. Attached are the screenshots
Pegasystems Inc.
US
Is the \\nasgwss0021pn.uhn.com your app server node? If you run with just \pas\PASdev\BIX do you see the output in that directory? It isn't throwing an error that it cannot write to that output so it seems like it is writing it somewhere. What specific version of Pega/BIX 7.1 is this?
GalaxE.Solutions
US
Yes it is my node. But when I run with \pas\PASdev\BIX, it says no directory found.
Yes, it is writing somewhere but could not identify it in the given path. am using 7.1.6 of pega and 7.1 of Bix.
Pegasystems Inc.
US
You are saying it is your node but is it the node where the application server is actually running? It seems like it is not the actual app server node as when you try to write to that directory it is telling you there isn't a directory /pas/PASdev/BIX
GalaxE.Solutions
US
Actually I have the write access in the node physical folders, but I am not able to understand why the ddl is not getting saved into this node I specified. For, ddl, below is the screenshot
Pegasystems
IN
So you are saying that even though on the screenshot it says creating schema file to "\\nasgwss0021pn.uhc.com\pas\PASdev\BIX.sql", there is no file called BIX.sql present? And there are no errors in BIX log file?
Also, DDL (schema) generation is not required if your extract type is CSV.
Accepted Solution
GalaxE.Solutions
US
Yes, Actually we were trying with DB schema. So, Generated DDL for that purpose. The issue is resolved now.
The reason for that issue is we were trying to extract the records from the Framework layer rather than the Implementation layer. Thanks for your help Celeste and Rajiv.