{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"Configuration in repository.cfg","type":"text"}]},{"type":"codeBlock","attrs":{"language":"none"},"content":[{"text":".protocolservice.type=database\n.protocolservice.database.driver=\n.protocolservice.database.url=\n.protocolservice.database.user=\n.protocolservice.database.password=\n#.protocolservice.database.read-connections.max= #default: 32, not after 2.7.0\n#.protocolservice.database.read-connections.min= #default: 32, not after 2.7.0\n#.protocolservice.database.read-connections.shared= #default: false, not after 2.7.0\n#.protocolservice.database.write-connections.max= #default: 32, not after 2.7.0\n#.protocolservice.database.write-connections.min= #default: 32, not after 2.7.0\n#.protocolservice.database.cache-statements= #default: false, not after 2.7.0\n#.protocolservice.database.cache-statements.size= #default: 50, not after 2.7.0\n#.protocolservice.database.minimumIdle= #default: 10 minimumPoolSize\n#.protocolservice.database.maximumPoolSize= #default: 10 maximumPoolSize\n#.protocolservice.database.connectionTimeout= #default: 30000 duration after a connection lease request will time out\n#.protocolservice.database.idleTimeout= #default: 600000 duration after idle connection will be closed\n#.protocolservice.database.keepaliveTime= #default: 0\n#.protocolservice.database.maxLifetime= #default: 1800000\n#.protocolservice.database.scripts= #default: classpath:sql/prot/migration/h2|sqlserver|oracle, dependening on database provider , 3.0.0+","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"As of version 2.7.0 we switched from EclipseLink to Hibernate, therefore some parameters have changed.","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"As of version 3.4.0 the connection pool handling was improved. It allows using a smaller number of connections, i.e. changing the parameter minimumIdle to 1 should lower the utilization of the database without significant impact on overall performance.","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"H2","type":"text"}]},{"type":"codeBlock","attrs":{"language":"none"},"content":[{"text":".protocolservice.database.driver=org.h2.Driver\n.protocolservice.database.url=jdbc:h2:C:/h2db.db;FILE_LOCK=FS;TRACE_LEVEL_SYSTEM_OUT=0","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Oracle","type":"text"}]},{"type":"codeBlock","attrs":{"language":"none"},"content":[{"text":".protocolservice.database.driver=oracle.jdbc.OracleDriver\n.protocolservice.database.url=jdbc:oracle:thin:@localhost:49161:xe","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"MSSQL","type":"text"}]},{"type":"codeBlock","content":[{"text":".protocolservice.database.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver\n.protocolservice.database.url=jdbc:sqlserver://localhost:1433;databaseName=CONTENTSERVER;","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Required Configuration for Searching in Protocols:","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Make sure that your configuration has the following values:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\nFI.protocolservice.document.properties=name,contentlength,path,contentDigest\nFI.protocolservice.container.properties= name,path\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Supported values for document:","type":"text"},{"type":"hardBreak"},{"text":"starttime,endtime,requestid,path,id,respository,status,message,command,object,module,client,user,objectcommand,objectid,contentLength,contentType,contentDisposition,contentDigest,contentDigestAlgorithm,contentEncoding,creationTime,modificationTime,creationUser,modificationUser","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"Supported values for container:","type":"text"}]},{"type":"paragraph","content":[{"text":"name,path","type":"text","marks":[{"type":"code"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Tables:","type":"text"}]},{"type":"paragraph","content":[{"text":"PROTOCOL","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Contains one record per access, defines acces modul and access data","type":"text"}]},{"type":"expand","attrs":{"title":"Table create Scripted (based on MS SQL)"},"content":[{"type":"paragraph","content":[{"text":"CREATE TABLE [dbo].[PROTOCOL](","type":"text"},{"type":"hardBreak"},{"text":"\t[RECORDID] [numeric](19, 0) NOT NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[CLIENT] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[COMMANDCATEGORY] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[COMMANDMESSAGE] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"2048"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[COMMANDNAME] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[COMMANDOBJECT] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[COMMANDSTATUS] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[COMMANDSTATUSCODE] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[ENDTIME] ","type":"text"},{"text":"datetime2","type":"text","marks":[{"type":"link","attrs":{"href":"7"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[MODULENAME] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[NODENAME] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[OBJECTID] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"1024"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[REPOSITORYNAME] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NOT NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[REQUESTID] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NOT NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[STARTTIME] ","type":"text"},{"text":"datetime2","type":"text","marks":[{"type":"link","attrs":{"href":"7"}}]},{"text":" NOT NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[USERNAME] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[VERSION] [int] NULL,","type":"text"},{"type":"hardBreak"},{"text":"PRIMARY KEY CLUSTERED","type":"text"},{"type":"hardBreak"},{"text":"(","type":"text"},{"type":"hardBreak"},{"text":"\t[RECORDID] ASC","type":"text"},{"type":"hardBreak"},{"text":")WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]","type":"text"},{"type":"hardBreak"},{"text":") ON [PRIMARY]","type":"text"},{"type":"hardBreak"},{"text":"GO","type":"text"}]}]},{"type":"paragraph","content":[{"text":"PROTKEY_VALUES","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"multiple records per access, contains details according to configuration","type":"text"}]},{"type":"expand","attrs":{"title":"Table create script (based on MSSQL)"},"content":[{"type":"paragraph","content":[{"text":"CREATE TABLE [dbo].[PROTKEY_VALUES](","type":"text"},{"type":"hardBreak"},{"text":"\t[ID] [numeric](19, 0) NOT NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[FIELDBOOLVALUE] [bit] NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[FIELDDATETIMEVALUE] ","type":"text"},{"text":"datetime2","type":"text","marks":[{"type":"link","attrs":{"href":"7"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[FIELDDECIMALVALUE] [numeric](28, 0) NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[FIELDINTVALUE] [numeric](28, 0) NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[FIELDSTRINGVALUE] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"1024"}}]},{"text":" NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[TYPEID] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NOT NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[RECORDID] [numeric](19, 0) NOT NULL,","type":"text"},{"type":"hardBreak"},{"text":"\t[FIELDID] ","type":"text"},{"text":"varchar","type":"text","marks":[{"type":"link","attrs":{"href":"255"}}]},{"text":" NOT NULL,","type":"text"},{"type":"hardBreak"},{"text":"PRIMARY KEY CLUSTERED","type":"text"},{"type":"hardBreak"},{"text":"(","type":"text"},{"type":"hardBreak"},{"text":"\t[ID] ASC","type":"text"},{"type":"hardBreak"},{"text":")WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]","type":"text"},{"type":"hardBreak"},{"text":") ON [PRIMARY]","type":"text"},{"type":"hardBreak"},{"text":"GO","type":"text"}]},{"type":"paragraph","content":[{"text":"ALTER TABLE [dbo].[PROTKEY_VALUES] ADD DEFAULT ((0)) FOR [FIELDBOOLVALUE]","type":"text"},{"type":"hardBreak"},{"text":"GO","type":"text"}]},{"type":"paragraph","content":[{"text":"ALTER TABLE [dbo].[PROTKEY_VALUES] WITH CHECK ADD CONSTRAINT [PROTKEY_VALUESRECORDID] FOREIGN KEY([RECORDID])","type":"text"},{"type":"hardBreak"},{"text":"REFERENCES [dbo].[PROTOCOL] ([RECORDID])","type":"text"},{"type":"hardBreak"},{"text":"GO","type":"text"}]},{"type":"paragraph","content":[{"text":"ALTER TABLE [dbo].[PROTKEY_VALUES] CHECK CONSTRAINT [PROTKEY_VALUESRECORDID]","type":"text"},{"type":"hardBreak"},{"text":"GO","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Example Queries (based on MSSQL)","type":"text"}]},{"type":"paragraph","content":[{"text":"find all Entries","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"SELECT p.*, pv.FIELDSTRINGVALUE as 'Path'\n FROM [PROTOCOL] p\n inner join PROTKEY_VALUES pv on p.RECORDID = pv.RECORDID\n where pv.FIELDID = 'path'","type":"text"}]},{"type":"paragraph","content":[{"text":"find read entries only ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"you can replace “read“ with the following values to get only certain categories:","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"c073efaa-8340-4f21-8419-edfbc3386892"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"Value","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"read","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"all read access to a folder or document (only CMIS/ILM)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"create","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"all create folder or document entries","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"update","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"all update requests","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"delete","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"all delete requests for folder or documents","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"info","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"for info requests (AricheLink or ILM)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"admin","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"all admin access like create put certificate or serverInfo","type":"text"}]}]}]}]},{"type":"codeBlock","content":[{"text":"SELECT p.*, pv.FIELDSTRINGVALUE as 'Path'\n FROM [PROTOCOL] p\n inner join PROTKEY_VALUES pv on p.RECORDID = pv.RECORDID\n where pv.FIELDID = 'path' \n and p.COMMANDCATEGORY = 'read'","type":"text"}]},{"type":"paragraph","content":[{"text":"ArchiveLink based Queries","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"All protocols ArchiveLink entries:","type":"text"}]},{"type":"paragraph","content":[{"text":"Protocols for documents and components create seperate protocoll entries. A “Create” exists for creation of the document and for each component. Same applies for other commands.","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"d5224764-4828-47f1-b8c8-7d5b62f2bf21"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"COMMANDOBJECT","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"document","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"Protocols for the ArchiveLink Component","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"container","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[380.0]},"content":[{"type":"paragraph","content":[{"text":"Protocol for the ArchiveLink Document","type":"text"}]}]}]}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"select CLIENT,COMMANDOBJECT,COMMANDMESSAGE, COMMANDCATEGORY,COMMANDSTATUS,STARTTIME,ENDTIME,MODULENAME,REPOSITORYNAME,REQUESTID,\n (select FIELDSTRINGVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'path' and prot.COMMANDOBJECT = 'document') as DOCUMENT,\n (select FIELDSTRINGVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'name' and prot.COMMANDOBJECT = 'document') as COMPONENT,\n (select FIELDINTVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'contentlength' and prot.COMMANDOBJECT = 'document') as SIZE,\n (select FIELDSTRINGVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'contentDigest' and prot.COMMANDOBJECT = 'document') as HASHVALUE\n from Protocol p\n where MODULENAME = 'ContentServer4ArchiveLink'","type":"text"}]},{"type":"paragraph","content":[{"text":"Filter based on docID:","type":"text"}]},{"type":"paragraph","content":[{"text":"Enter docID instead of example value ","type":"text"},{"text":"85DCD9A03683496DB7B9A8BFED0EBEAD","type":"text","marks":[{"type":"code"}]}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":" select*, CLIENT,COMMANDOBJECT,COMMANDMESSAGE, COMMANDCATEGORY,COMMANDSTATUS,STARTTIME,ENDTIME,MODULENAME,REPOSITORYNAME,REQUESTID, pv.FIELDSTRINGVALUE as 'PATH',\n (select FIELDINTVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'contentlength' and prot.COMMANDOBJECT = 'document') as SIZE,\n (select FIELDSTRINGVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'contentDigest' and prot.COMMANDOBJECT = 'document') as HASHVALUE\n from Protocol p\n inner join PROTKEY_VALUES pv on p.RECORDID = pv.RECORDID and pv.FIELDID = 'path'\n where pv.FIELDID = 'path'\n and MODULENAME = 'ContentServer4ArchiveLink'\n and pv.FIELDSTRINGVALUE like '%85DCD9A03683496DB7B9A8BFED0EBEAD%'","type":"text"}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"paragraph"}],"version":1}

Browser not supported