Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HTML
<style>
.release-box {
	height: 30px; 
	width: 100px; 
	padding-top: 8px;
	text-align: center; 
	border-radius: 5px; 
	font-weight: bold; 
	background-color: #d4af37;  
	border-color: #FCE28A;
}

.release-box:hover {
  	cursor: hand;
    cursor: pointer;
    opacity: .9; 
}
</style>
<meta name="robots" content="noindex">

<div class="release-box">
<a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</a>
</div>




UI Expand
titleAlter a scoped application table for bulk sharing


Divbox
stylebackground:white

To bulk/dynamic share tables that are in a scoped application that have restricted access, you will need to alter the table's Application Access. To do so, follow these steps: 


UI Steps
sizesmall


UI Step

In your ServiceNow instance, go to System Definition > Tables.


UI Step

Click into the

table record you

record for the table (such as sn_hr_core_case) you want to use for bulk/dynamic sharing. 


UI Step

In the Application Access tab, select None for the Caller Access dropdown. Then, Update the form. 


UI Step

Continue to 

Can't find what you're looking for?  

See Troubleshooting DataSync for ServiceNow Issues or browse the Perspectium Community Forum.

Similar topics

Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
cqllabel = "datasync-for-servicenow" and space = currentSpace()

Create a ServiceNow bulk share or Create a ServiceNow dynamic share.





UI Expand
titleHow do I validate my dynamic shares?


Divbox
stylebackground:white;

To validate that the records in your previously configured dynamic shares are being shared correctly:

UI Steps
sizesmall


UI Step

Navigate to Perspectium > Shares > Dynamic Share > View Dynamic Shares in ServiceNow and click the Dynamic Share you want to validate.


UI Step

At the top right-hand corner of the page, click the magnifying glass icon to the right of the Test With field.

Image Added


UI Step

In the pop-up window, search for the record you want to test for by clicking the magnifying glass icon to the right of the Document field. Click the record you want to test and then click OK.


UI Step

At the top right-hand corner of the navigation bar, click the Test Record button. Notifications for the record you are testing will then appear at the top of the screen.

Image Added





UI Expand
titleHow do I replicate into a Local Timezone?


Divbox
stylebackground:white;

Date/Time fields in ServiceNow are stored in the database in UTC timezone. They are adjusted for the individual user’s local timezone as defined by their profile at runtime in the UI. This allows anyone viewing the data to see date/time values in their local timezone to avoid confusion. When we replicate that data we just replicate it as is in UTC, and write it to the target without doing any kind of timezone offset since there isn’t one in the context of a machine integration. Typically reporting solutions can account for this and adjust based on your end user’s needs.

This is fairly standard across most enterprise applications.

UI Text Box
typenote

If you want to explicitly convert all data to a specific timezone for replication you can use a “Before Share Script” in bulk shares and dynamic shares to do this. We DO NOT recommend it, as it can cause issues if the reporting or viewing technology being uses then adjusts it again in their UI. You also need to consider the impact of Daylight Savings. Something converted and replicated during Standard Time, could be off by an hour compared to something converted during Daylight Savings time.

A simple example script to do this here shows converting sys_updated_on and opened_at to US/Eastern timezone during replication.

Code Block
// Date/Time variables you want to update
var timesToUpdate = ["opened_at", "sys_updated_on"];
var curTimeZone = "America/New_York";
 
// Get the specified timezone
var tz = Packages.java.util.TimeZone.getTimeZone(curTimeZone);
 
// Edit specified variables with the offset
var time;
var timeZoneOffset;
for(var t in timesToUpdate){
	time = new GlideDateTime(current.getValue(timesToUpdate[t]));
	time.setTZ(tz);
	timeZoneOffset = time.getTZOffset();
	time.setNumericValue(time.getNumericValue() + timeZoneOffset);
	current.setValue(timesToUpdate[t], time);
}

You would place this in the Before Share Script section for any shares where you need it, and specify those fields you want to convert.



UI Expand
titleHow do I detect long running bulk shares?


Divbox
stylebackground:white;

Bulk shares are monitored periodically every hour to ensure proper functionality and stability. A scheduled task will check each bulk share and calculate the time the bulk share has been running. If the bulk share exceeds the threshold of 12 hours, a log message will be sent to the Perspectium - Logs module. The message will have a “Type” of “error” and a “Name” of “PerspectiumReplicator.BulkShareMonitor” and can be subscribed to using Error Notifications.

Image Added



UI Expand
titleWhen choosing flow designer for dynamic share, why do I see more than one flow designer created?


Divbox
stylebackground:white;

Before the Paris release of ServiceNow, Flow Designer's did not include extended records as a triggering option. Thus, to capture any creates or updates from an extended record, i.e. incident from task, additional Flow Designer's are needed. 

So, if you create a dynamic share with task as the Table, you will see additional Flow Designers created for its extended tables such as incident. 






Can't find what you're looking for?  

See Troubleshooting DataSync for ServiceNow Issues or browse the Perspectium Community Forum.

Contact Perspectium Support

Image RemovedUS: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com