Hi Tani,

Indeed, we've talked with our client. We agreed that temporarily open audit log is OK for  trouble shooting, while we will need to make audit/cleaning process a more formal process as part of their data quality control solution.

I'll refer to the example above for them in the solution we are working on. Thanks a lot .

Thanks guys. We are using audit log now to trace the deletions. 

Both truncate table statement and delete statement are logged as SQL DELETE Statement in table %SYS.Audit. Of cause, after the audit of XDBCStatement was enabled, the size of Audit Database increased rapidly (I.E 300MB for 100000 insertions in a table of only 5 fields ).

Developers who want to trace SQL execution need to be aware of much more disk space consumption and prepare that in advance.

Indeed. Thanks a lot.

Hi Robert，

Thank you very much for your help.

So far we simply used exported csv files to load legacy data. 

During the tests, we found:

1. Under Hive JDBC drivers:

a. By changing rowkey to Varchar(255) is not working. Data migration and link table tasks all failed.

b. Using sql inbound adapter to read data is not working either(select * from sometable), the query failed due to the missing of some toCLOB(0,2) method in the jdbc driver

2. then we tried hive odbc driver

a.  link table task succeed

b. we can use sql to select * from linked table which can also be used with sql inbound adapter. But when we used where clause (select * from sometable where rowkey=' a long string key'), the query failed again due to the follwoing error:

Any idea?

Dear Lexi,

I've assigned the DB resource to the  application, unfortunately it's still not working.

Anyway, we bypassed the problem. Thank you for your help.

Thanks Paul. I'll try other approaches to bypass it.

Thanks Bernd.

We'll try other approaches.

It works, Than you very much

Thanks guys. I've finished the tasks except for mirroring.

When I use SYS.Mirror to create mirror set：

%SYS>set tSC = ##class(SYS.Mirror).CreateNewMirrorSet("TestSet",sysName,,)

It failed because:

SYS>zw tSC
tSC="0 "_$lb($lb(2066,,,,,,,,,$lb(,"%SYS",$lb("e^zCreateNewMirror+9^SYS.MirrorConfiguration.1^1","e^zCreateNewMirrorSet+48^SYS.Mirror.1^1","e^^^0"))))/* ERROR #2066: Mirroring Service is required but not enabled */

Then the question is how may I enable %Service_Mirror  programtically

Thanks again

Thanks Eduard. But not exactly.

With the use of SoapAction, we can rename the soapAction attribute as below:

<soap:operation soapAction="Get_PatientInfo" style="document"/>

What they want is actually to change the name of the operation.

That is really cool, thanks!

A million thanks. This works and my pivot table can work now. 

I'll recommend it to my team members, thank you.

HI Samuel,

     I've tried several times using DeepSee Folder Manager to do the job but unfortunately it did not work.

The following is the steps I've tried, would you mind help me in figuring out what was wrong about them?

1. I've written a Cube class named as Test.TestCube, basically it is only a copy of HSAA.PatientCube. The definition of the cube was written as below:

Class Test.TestCube Extends %DeepSee.CubeDefinition [ DependsOn = (HSAA.Patient, HSAA.PatientOverrides, HSAA.PatientCurrentConditionsCube, HSAA.EnteredAtCube) ]
{

/// Cube definition from Architect.
XData Cube [ XMLNamespace = "http://www.intersystems.com/deepsee" ]
{
<cube xmlns="http://www.intersystems.com/deepsee" name="TestCube" displayName="TestCube" disabled="false" inheritsFrom="PatientDetails" abstract="false" actionClass="HSAA.KPI.PatientActions" owner="_SYSTEM" caption="TestCube" countMeasureName="%COUNT" bucketSize="8" bitmapChunkInMemory="false" precompute="0" disableListingGroups="false">

2. Then I defined a pivot table as GenderDistribution which depend on two calculated dimensions as Female and Male respectively:

3. then I first export the cube and imported it into another environment, compile and builded the cube

4. And I exported the pivot table with Folder Manager as below:

5. I updated the exported file to another instance and used Folder Manager to import it, but the calculated members are still missing and my pivot table fails to load:

Thanks.

Hi Samuel,

Thank you for your help. I'll try it and feedback later.