Results 1 to 8 of 8
  1. #1
    Join Date
    May 2013
    Posts
    3

    Unanswered: Need urgent help

    Hi,

    I am new to pervasive, please help to find some good document for data integration v10 and
    I need help in the following issue:
    I need to generate extract by runing query.
    the source will me sqlserver 2008
    and output will be file.

    I done creating the source with sqlserver2008 and able to see the result from the table.but when i try to create target with the ascii for flat flie , i not able to generate the extract.

    Please help me..

    Thanks,
    Gurpreet Singh

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm confused by your post.

    It appears that your data is currently on Microsoft SQL Server 2008 and that you want to put that data into a text file.

    Is this correct, and if it is correct why is the question posted in the Pervasive forum? I'm just confused, not upset... Please explain.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    May 2013
    Posts
    3
    Quote Originally Posted by Pat Phelan View Post
    I'm confused by your post.

    It appears that your data is currently on Microsoft SQL Server 2008 and that you want to put that data into a text file.

    Is this correct, and if it is correct why is the question posted in the Pervasive forum? I'm just confused, not upset... Please explain.

    -PatP
    Yes ur are correct, but i want that to be done through Pervasive.

    and thanks for the replay...

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This is a trivial task using the SQL Server tools, but it is comparatively slow and complicated using Pervasive. Because of that, I haven't used the Pervasive tools for many years.

    Good luck finding someone that can help you to extract this data using the Pervasive tools!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    The Pervasive Integration tools are different that the Pervasvie PSQL database engine. What you are trying to do is a fairly trivial task using the Integration tools.

    You posted that you weren't able to generate the flat file. Are you getting an error? If not, what behavior are you seeing?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  6. #6
    Join Date
    May 2013
    Posts
    3
    Thanks Mirtheil.
    Let me explain the way i am doing.
    First i created one source dataset of type sqlserver 2008 and save the same with xaa schema name and i can see the data in the preview part so source is working fine.
    then i created one target dataset with ASCII fixed or delimited and attached the source schema to this,
    then i try to map both the source and target, when i try to run i get some error messages
    which i pasted below:

    1) BEGIN LOG ----------
    2013-05-20 07:52:35(CDT) com.pervasive.di.client.sdk.embedded.shared.engine server.ECEngineFacade loadSpec
    SEVERE:
    DataJunction.ec.ECException: Dataset is empty target 'TARGET_2'
    at DataJunction.ec.MapEngine.syncLoad(Native Method)
    at DataJunction.ec.MapEngine.Load(Unknown Source)

    2) error message:
    05/20/2013 08:04:50 1 0 O Global ### Owner: Carewise Health
    05/20/2013 08:04:50 1 0 O Global ### Organization: Carewise Health
    05/20/2013 08:04:50 1 0 O Global ### Serial Number: D121-295430
    05/20/2013 08:04:50 1 0 O Global ### Product Name: Pervasive Data Integrator Enterprise Development
    05/20/2013 08:04:50 1 0 O Global ### Product Build Version/Date: 10.2.6-97 - 04/05/2013
    05/20/2013 08:04:50 1 0 O Global *** Execution Initialization: [TEST_MAP2]
    05/20/2013 08:04:50 1 0 O Global *** Execution Begin: [TEST_MAP2]
    05/20/2013 08:04:50 4 27 E ASCII (Fixed) Error 401 sending POST message: An Authentication object was not found in the SecurityContext
    05/20/2013 08:04:50 1 0 O Global *** Execution End: [TEST_MAP2] completed successfully
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] executed in 0.163 seconds
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records read: 25
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records written: 25
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records inserted: 25
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records updated: 0
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records deleted: 0
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records discarded: 0
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records rejected: 0
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total error count: 0

    So Basically i am getting 2 error one the target source is empty
    and the second authentication error.

    So can u please help to sort this problem

  7. #7
    Join Date
    Aug 2013
    Posts
    1

    Smile

    Quote Originally Posted by guru.4me View Post
    Thanks Mirtheil.
    Let me explain the way i am doing.
    First i created one source dataset of type sqlserver 2008 and save the same with xaa schema name and i can see the data in the preview part so source is working fine.
    then i created one target dataset with ASCII fixed or delimited and attached the source schema to this,
    then i try to map both the source and target, when i try to run i get some error messages
    which i pasted below:

    1) BEGIN LOG ----------
    2013-05-20 07:52:35(CDT) com.pervasive.di.client.sdk.embedded.shared.engine server.ECEngineFacade loadSpec
    SEVERE:
    DataJunction.ec.ECException: Dataset is empty target 'TARGET_2'
    at DataJunction.ec.MapEngine.syncLoad(Native Method)
    at DataJunction.ec.MapEngine.Load(Unknown Source)

    2) error message:
    05/20/2013 08:04:50 1 0 O Global ### Owner: Carewise Health
    05/20/2013 08:04:50 1 0 O Global ### Organization: Carewise Health
    05/20/2013 08:04:50 1 0 O Global ### Serial Number: D121-295430
    05/20/2013 08:04:50 1 0 O Global ### Product Name: Pervasive Data Integrator Enterprise Development
    05/20/2013 08:04:50 1 0 O Global ### Product Build Version/Date: 10.2.6-97 - 04/05/2013
    05/20/2013 08:04:50 1 0 O Global *** Execution Initialization: [TEST_MAP2]
    05/20/2013 08:04:50 1 0 O Global *** Execution Begin: [TEST_MAP2]
    05/20/2013 08:04:50 4 27 E ASCII (Fixed) Error 401 sending POST message: An Authentication object was not found in the SecurityContext
    05/20/2013 08:04:50 1 0 O Global *** Execution End: [TEST_MAP2] completed successfully
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] executed in 0.163 seconds
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records read: 25
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records written: 25
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records inserted: 25
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records updated: 0
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records deleted: 0
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records discarded: 0
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total records rejected: 0
    05/20/2013 08:04:50 1 0 O Global *** Execution Statistics: [TEST_MAP2] Total error count: 0

    So Basically i am getting 2 error one the target source is empty
    and the second authentication error.

    So can u please help to sort this problem
    Can someone answer the query posted above. I am seeing exactly the same error which trying to read data from a SQL server table and write it to an output file using Pervasive.

    My source reads from a table in SQL server 2008 and is returning values in the 'preview' section.

    My target file is a .csv/.txt file. When I run the map, it is throwing an error similar to the one posted above.
    -----
    08/22/2013 11:04:50 4 27 E ASCII (Delimited) Error 401 sending POST message: An Authentication object was not found in the SecurityContext
    -----

    I tried all means but in vain. I even deleted the complete project and recreated it. But the error is not getting resolved.

    P.S.: WHEN I RAN IT FOR THE FIRST TIME ABOUT A WEEK AGO, IT WORKED FINE AND THE TARGET FILE WAS CREATED WITHOUT ANY ISSUES. AND I HAVE NOT MADE ANY CHANGES AFTER THAT. BUT WHEN I TRIED TO RUN THE MAP AFTER A GAP OF 2 DAYS, IT STARTED THROWING UP.

    Can some one please help me resolve this issue.

    Thanks in advance...

  8. #8
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Can someone answer the query posted above. I am seeing exactly the same error which trying to read data from a SQL server table and write it to an output file using Pervasive.
    I tried all means but in vain. I even deleted the complete project and recreated it. But the error is not getting resolved.

    P.S.: WHEN I RAN IT FOR THE FIRST TIME ABOUT A WEEK AGO, IT WORKED FINE AND THE TARGET FILE WAS CREATED WITHOUT ANY ISSUES. AND I HAVE NOT MADE ANY CHANGES AFTER THAT. BUT WHEN I TRIED TO RUN THE MAP AFTER A GAP OF 2 DAYS, IT STARTED THROWING UP.

    Can some one please help me resolve this issue.

    Thanks in advance...
    If you are seeing the exact error message from the previous post:
    05/20/2013 08:04:50 4 27 E ASCII (Fixed) Error 401 sending POST message: An Authentication object was not found in the SecurityContext
    My guess is that you have a licensing issue.

    NOTE: Next time, start a new thread and reference the original thread. Don't post in an old thread with a "me too" type response. Also, give specific information on your problem, versions of software you are using, what you've tried, and what you expect. You'll get a better response.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •