OnDemand User Group

Off Topic => General => Topic started by: Arvindanathan on June 24, 2013, 12:06:26 AM

Title: How to import indexed data to database after indexing the application.?
Post by: Arvindanathan on June 24, 2013, 12:06:26 AM
How to import indexed data to database after indexing the application.? Can some one help me to do this. I need code to import indexed data to database
Title: Re: How to import indexed data to database after indexing the application.?
Post by: Arvindanathan on June 24, 2013, 05:45:02 AM
can anybody help on this..
how to import the indexed data to the database. I am using the SQL SERVER 2008.

Thanks in advance
Title: Re: How to import indexed data to database after indexing the application.?
Post by: Justin Derrick on June 24, 2013, 07:25:35 AM
You need to give us more information -- help us to help you!

What versions of software are you using?  What sort of data are you loading?  How are you indexing it?  What have you tried?  What was the output of the commands you've tried?  If it didn't work, what was the error?  Was the result different than what you expected?  What did you expect to happen?  How was the result different from your expectation?

-JD.
Title: Re: How to import indexed data to database after indexing the application.?
Post by: Arvindanathan on June 24, 2013, 09:43:15 PM
Hi,
am using the OnDemand 8.4.1 version, and am indexing the AFP File and am not able to load it in the DataBase. I have indexed the Report file and created the two fields on indexing i.e Applicant Name and Applicant account Number.

I have tried by the commands to load it into the DB but am not able to export it.

C:\Program Files (x86)\IBM\OnDemand for WinNT\bin>arsload -u admin -p xxxxxxxx -
g Test1001 C:\Mark\000000BP.DAF.u_F0000000001.AFP

arsload: Processing file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
The application group >Test1001< does not exist or user >admin< does not have pe
rmission to access the application group

arsload: Processing failed for file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

when we check in the search criteria we are not able to get the records and showing the error that "NO DOCUMENTS MEET THE SEARCH"


Thanks You :)

Edited to remove cleartext password.  -JD.
Title: Re: How to import indexed data to database after indexing the application.?
Post by: Frederick Tybalt on June 24, 2013, 11:57:59 PM
If this AG Test1001 had muliple applications mapped, you need to specifiy the Application also in arsload command with -a option.
Title: Re: How to import indexed data to database after indexing the application.?
Post by: Arvindanathan on June 25, 2013, 12:53:12 AM
OK Thanks, but the thing is the Application Group Test1001 contains only one application i.e Test1001 and i have mentioned the Folder name also as the Test1001.

I have checked it what you said, check the below command and the error

C:\Program Files (x86)\IBM\OnDemand for WinNT\bin>arsload -u admin -p xxxxxxx -
a AppTest  -g AppTest "C:\Mark\000000BP.DAF.u_F0000000001.AFP"
arsload: Processing file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<

arsload: Processing failed for file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

Thank You :)
Title: Re: How to import indexed data to database after indexing the application.?
Post by: Justin Derrick on June 25, 2013, 11:09:16 AM
Did you ever address the first error message?

Quote
The application group >Test1001< does not exist or user >admin< does not have pe
rmission to access the application group
Title: Re: How to import indexed data to database after indexing the application.?
Post by: Arvindanathan on June 25, 2013, 10:15:57 PM
Hi Justin,
i tried every thing is correct only what i have mentioned in the username and password.

but now we are getting the error

C:\Program Files (x86)\IBM\OnDemand for WinNT\bin>arsload -u username -p  password
-g "application Group name" "C:\Mark\000000BP.DAF.u_F0000000001.AFP"
arsload: Processing file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<

arsload: Processing failed for file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

please someone find the solution for this  :(

Thank You.

Title: Re: How to import indexed data to database after indexing the application.?
Post by: Frederick Tybalt on June 26, 2013, 12:31:06 AM
Try running with -v option to get more details.
Title: Re: How to import indexed data to database after indexing the application.?
Post by: Alessandro Perucchi on July 02, 2013, 10:57:12 PM
Quote from: Arvindanathan on June 25, 2013, 10:15:57 PM
i tried every thing is correct only what i have mentioned in the username and password.

but now we are getting the error

C:\Program Files (x86)\IBM\OnDemand for WinNT\bin>arsload -u username -p  password
-g "application Group name" "C:\Mark\000000BP.DAF.u_F0000000001.AFP"
arsload: Processing file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<

arsload: Processing failed for file >C:\Mark\000000BP.DAF.u_F0000000001.AFP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

please someone find the solution for this  :(

Hello Arvindanathan,

We are willing to help, but with so little information on your side, you are not helping us to help you.

So in order to be able to help you, please give us some informations like:


As long as you don't your homework, nobody here will be able to read your mind and help you.

Sincerely yours,
Alessandro