Using [SNAPSHOTVAR] In Ini File Does Not Work With Wsh, Null Error is returned (Doc ID 1642154.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database Mobile Server - Version 11.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.3.0.0.0 version, Mobile Server

When attempting to use wsh to set the data subsetting
the following error occurs.

ERROR
-----------------------
null


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Using DMS 11GR3 with wsh to populate the Data subsetting:
SQL> select * from mobileadmin.c$all_subscription_params where clientid='CYRIL75';
TEMPLATE | CLIENTID | PARAM_NAME | PARAM_VALUE
-------------+----------+-------------+------------
DEFAULT | CYRIL75 | CLIENTID | 'CYRIL75'
PUB_TEST_WSH | CYRIL75 | ADM_VERT_NR | NULL

I am using this test3.ini:
[DATABASE]
TYPE=ORACLE

[SNAPSHOTVAR]
NAME=PUB_TEST_WSH
PLATFORM=SQLite WIN32;US
VIRTUALPATH=/ccm_mobileadm
USER=CYRIL75
VAR=ADM_VERT_NR, 11

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms