Messages

16

MP Server / Re: Arsdoc get bringing separate metafiles

« on: May 18, 2018, 12:58:56 AM »

Hey jsquizz, are you really saving all the metafiles forever...
There are different size of Od:s
Jesus these wise guys

17

MP Server / Arsdoc get bringing separate metafiles

« on: May 16, 2018, 11:06:28 PM »

Hi, has anyone tried to import documents with arsdoc get so that there is separate metafile for each document.
Or is it so that -c parameter have to be connected to query when -g is presented

"For the GET function, use to generate Generic indexer data for the items that match the query.
See the IBM Content Manager OnDemand Indexing Reference for details about the Generic indexer."

This is bad when there is a need to rearchive generic index data material again.

T:Zeus

18

MP Server / Virtual Servers with Od

« on: October 24, 2017, 10:48:57 PM »

Hi everyone, We have Windows-Od (sql) 9.5 in physical Server and tsm in its own.
Is there any other concerns than performance with virtualization.

T:Tapsa

19

MP Server / Re: arsload only by document name

« on: October 07, 2015, 03:21:43 AM »

Hi, yes Vinothkumar_ve, that one I know too from the manuals.
I needed pure example how to load files with different names, with application "app" to application group "ag", and with what indexer.
Got around with this by doing little javaprog which generates ind file/files, but anyway curious to know how this could work with od-parameters, cause it should.

T:Zeus

20

MP Server / arsload only by document name

« on: September 10, 2015, 02:52:59 AM »

Hi !
Has anyone experience of loading files to od only with document name.
I know the parameters -B and -b, but how can I use them in practice.
I need also index from the name, say it is customernro.
Do I have to know the file names before load, and is the application type generic, or something else.
The files are scanned pdf:s, and pdf indexer cant get into them, and I would not like to start generating metadata files for loading.
thx in advance
Env win 2008, od 9.02, sql database

t:Zeus

21

MP Server / Re: Performing Data Migration

« on: July 14, 2015, 11:29:19 AM »

Hi! Not really my busines, but why use 8.4 for development or to anything else, quite a big step to 9.5...
Prefer to do a second instance in the monster server, or best of cause to have a test or development server.  Migrating/upgrading is quite smooth as drive letters are kept same. Otherwise its complicated.

22

MP Server / Re: Moving from CMOD V8.4.0.1 to CMOD V9.0

« on: October 06, 2014, 10:42:19 AM »

Hi Ach, you dont have to worry about the bits with database.
Just full backup from old database and then when you have new environment restore to new one.
After restore you have to run some update clauses to database which are in the guide in updating to 9.0 from old environment(in your case 8.4.1)
If you have some kind of test environment, or build test instance in the new environment is an other option too.
I can give you further hint if you need them later.
We have been in new environment(same as yours, much bigger allthough) about a year and everything is ok.

T:Zeus

23

MP Server / Re: Mass changes to many apps groups

« on: October 06, 2014, 10:26:50 AM »

Hi ddp!
The information is in the database, so one update clause.
Was it arsag table if i remember right.
I dont know how "correct" way this is  , but i have done these with some other settings.
At least in Sql database.
Try it with one group first

24

MP Server / Re: Moving from CMOD V8.4.0.1 to CMOD V9.0

« on: October 01, 2014, 12:26:17 AM »

Hello again !

Ach, i prefer in your case option 2 better because, first of all, support for TSM 5.5 versions ended in April 2014, and its way more secure to build a new environment while the old environment is running smoothly same time, updating is always more risky bisnes.
Besides newer TSM versions 6.2 -> offer quite much more features than the old ones.

You have not mentioned any volume details, or how business dependent ondemand is to your customer.

T:Zeus

25

MP Server / Re: Moving from CMOD V8.4.0.1 to CMOD V9.0

« on: September 20, 2014, 11:16:39 AM »

Hello, been there done that.
Our environment was the same except OD version 8.4.0.3.
You did not mention about TSM, is it on the same Server as OD or in separate.
Don't know if you already have done something, but option 1 not reasonable.
New setup with mentioned 2008 win and Sql Server 2008 R2 or 2013.
Actually in Sql 2013 the odbc driver did not work from scratch...had to install odbc driver version 10.
And Tsm in separate server, version 6.4 or higher, must be 64-bit environment.

I have exact steps but not reasonable to paste it here.
If you still need more information let me know.

Done this upgrade to 5 environments, one with Sql 2013, and others Od 9.0.0.2 with 2008 R2 and Tsm 6.4

26

MP Server / Ondemand 9.0.0.2 win and SQL Server 2012 ODBC-issue

« on: July 01, 2014, 12:04:57 PM »

Hello again, has anyone tried Ondemand 9.0.0.2 windows and SQL Server 2012, i thought it should work...
For some reason allthough while making new instance arsdb expects to find 2010 odbc-driver.
Registry confirms this bacause Odbc.ini folder is empty. It should contain odbc information and location of dll.
Of course it is possible to load 2010 odbc driver to 2012, but it sounds weird. Does not help if i make odbc connection to instance with 2012 driver. Then it comes to odbc.ini but arsdb fails anyway.
Can the 2010 odbc-dll be hardcoded to 9.0.0.2...
Might be that i am missing something, or i need a holiday, anyway i have installed about dozen times 9.0.0.2 winserver and sqlserver 2008R2 without problems.

T:Zeus

27

MP Server / Re: Problem during update v.8.4.0.3 to 9.0.0.1

« on: October 28, 2013, 01:45:04 AM »

Hi, yes unfortunately only a Typo error only, had to modify the query before pasting it.
Made a PMR to ibm, cant beliave that this is a bug, because the same is in the fresh new environment also.
Retrieval from two tables with UNION (same application group) is not working if order is made by date format.
Tried this several times. Below the same in "fresh" 9.0.0.1,

DECLARE @P1 date
DECLARE @P2 date
DECLARE @P3 int
DECLARE @P4 date
DECLARE @P5 date
DECLARE @P6 int
SET @P1 = '2013-08-02'
SET @P2 = '2013-10-24'
SET @P3 = '220589114'
SET @P4 = '2013-08-02'
SET @P5 = '2013-10-24'
SET @P6 = '220589114'

SELECT TOP 1001 *
FROM ((SELECT ODTBL.*, 'XGA3' AS ODTBL_NAME
FROM ondemand.XGA3 ODTBL
WHERE ODTBL.ARCHIVING_DATE BETWEEN @P1 AND @P2  AND  ( ODTBL.CUSNRO = @P3 ) )
UNION ALL (SELECT ODTBL.*, 'XGA2' AS ODTBL_NAME
FROM ondemandadmin.XGA2 ODTBL
WHERE ODTBL.ARCHIVING_DATE BETWEEN @P4 AND @P5  AND  ( ODTBL.CUSNRO = @P6 ) )) ODTMP
ORDER BY  LAJI, ODTBL.ARCHIVING_DATE DESC

And this is made by FOLDER, would be nice if there is some way to configure the sql that folders produce...

28

MP Server / Problem during update v.8.4.0.3 to 9.0.0.1

« on: October 19, 2013, 04:18:00 AM »

Hello again  , big post coming...

We are updating our windows based environment 8.4.0.3 to new version 9.0.0.1
Everything has went about fine so far in our smaller test environment, but after we made copy of our production environment, which contains in cache drives about 30 million documents came a weard problem with Sql, or with the difference how folders in od retrieve/produce sql statements.
Here is the problem.
In our Sql database we have few tables which contain more rows than 10.000.000 raws ,so od automatically renames the new tables that exceed 10 million with sequence number, for example ondemand.HAA1 and Ondemand.HAA2.
Now in old od (8.4) , when we retrieved documents with our odinterface(not od:s own client) the query looked like this
We used Od:s certain folder where we made above limits

SELECT ODTBL.*, ''HAA1''
FROM ondemand.HAA1 ODTBL
WHERE ARCHIVE_DATE BETWEEN 15341 AND 15706 AND ( custnro = 660365097 ) 
UNION ALL SELECT ODTBL.*, ''HAA2'' FROM ondemand.HAA2 ODTBL
WHERE ARCHIVE_DATE BETWEEN 15341 AND 15706 AND ( custnro = 660365097 ) 
ORDER BY  INSURANCE, ARCHIVE_DATE DESC

so it retrieved from two tables, but now in version 9.0.0.1 after all the updatesteps the same retrieval looks like

((SELECT ODTBL.*, 'HAA1' AS ODTBL_NAME
FROM ondemand.HAA1 ODTBL WHERE ODTBL.ARCHIVE_DATE BETWEEN 15341 AND 15706
AND  ( ODTBL.custnro = 660365097) )
UNION ALL
(SELECT ODTBL.*, 'HAA2' AS ODTBL_NAME
FROM ondemand.HAA3 ODTBL WHERE ODTBL.ARCHIVE_DATE BETWEEN 15341 AND 15706
AND  ( ODTBL.custnro = 660365097 ) )) ODTMP
ORDER BY  LAJI, ODTBL.ARCHIVE_DATE DESC

and this sql gives
error Msg 4104, Level 16, State 1, Line 23
The multi-part identifier "ODTBL.ARCHIVE_DATE " could not be bound.

First i thought that this was because in version 9 dates are handled differentially( converts old date to new format) but maybe this is just how sql version 2008 r2 operates, in our older environment we had sql server 2005, but actually we are running this new in compatibility mode 2005.

Is there a way to remove correlation names from the query, i mean in sql server, we have to use od:s folder anyway, in the folder configurations there is not nothing much to do.
Any Tips

29

Windows Client / Re: Pdf-reader for Ondemand

« on: October 01, 2013, 10:10:45 PM »

Yes thanks, no mention to be rude, just struggling with citrix-environment (client installed), have web-userinterface too which is the main use source.
Have already about 300 applications with data type pdf, so changing those is not really attempting and anyway for so many users as we have, its better to use "pdf" data type.
Anyway sunny day 

30

Windows Client / Pdf-reader for Ondemand

« on: September 30, 2013, 11:25:10 PM »

Hello everyone !

Is it really so that Ondemand client (version 9.0) needs adobe standard for pdf reading.
According to this http://www-01.ibm.com/support/docview.wss?uid=swg21046703
it truly does.
I tried it quickly with new adobe reader and it does not work
Or does anyone know other pdf readers which are free and opperate with od better.

T:Zeus