en

Problem Notes for SAS®9 - 65940: You might receive "ERROR: PI Point not found" when you query a PI tag name that contains a special character such as an ampersand (&)

When you query a PI tag name or element that contains a special character, such as an ampersand (&), you might receive the following error:



en

Problem Notes for SAS®9 - 65939: "ERROR: Unable to transcode data to/from UCS-2 encoding" occurs when you run an SQL query using SAS/ACCESS Interface to ODBC on SAS 9.4M5 with UTF-8

When you run an SQL query using SAS/ACCESS Interface to ODBC under the following conditions, you might receive an error: You run SAS 9.4M5 (TS1M5) or SAS 9.4M6 (TS1M6)  i




en

Problem Notes for SAS®9 - 65938: Incorrect values might be written to Hadoop for columns defined with the BIGINT data type

Large numeric values consisting of 16 digits in SAS might be incorrect when written to Hadoop for columns defined with the BIGINT data type.  This problem was introduced in SAS 9




en

Problem Notes for SAS®9 - 65900: Registering an Oracle table to the metadata might fail and generate an error

When you register an Oracle table to the metadata, it might fail and generate an error similar to the following: "ERROR: An exception has been encountered...ERROR: Read Access Violation METALIB..."




en

Problem Notes for SAS®9 - 35066: When a bulk-loading process fails with "SQL*Loader 2026" error, error message appears as a warning in the SAS log

If a bulk-loading process fails when you use SAS with SAS/ACCESS Interface to Oracle, you will receive the warning: "WARNING: All or some rows were rejected/discarded.: The actual error is "SQL*Loader-2026: The load was aborted because SQL




en

Problem Notes for SAS®9 - 65834: PROC METADATA returns various errors when the input contains certain multi-byte characters

The METADATA procedure might return an error similar to one of the following:

  • ERROR: Missing root element definition.
  • Full Article


  • en

    Problem Notes for SAS®9 - 65899: "ERROR: ORACLE disconnect error: ORA-03135" occurs when SAS disconnects from the Oracle database server

    When you run 32-bit SAS on Windows and disconnect from the Oracle database server, you might see the error: "ERROR: ORACLE disconnect error: ORA-03135: connection lost contact."




    en

    Problem Notes for SAS®9 - 65918: SAS Workflow Services fails to respond after a com.sas.workflow.engine.policy.PolicyExecutionException error occurs for a workflow instance

    When the problem occurs, you are unable to perform any workflow actions in a SAS solution that uses SAS Workflow Services.




    en

    Problem Notes for SAS®9 - 65929: A grid-enabled sign-on to SAS 9.4M6 (TS1M6) fails with errors, including "Remote signon … canceled"

    A sign-on to a grid-enabled environment fails while it is trying to communicate with the client host. The following errors then appear in the SAS log:


    en

    Problem Notes for SAS®9 - 64285: The SCD Type 2 Loader transformation in SAS Data Integration Studio generates "ERROR 22-322: Syntax error, expecting one of the following:..."

    If your business key column is a name literal, like " business key "n, a syntax error occurs when that variable name does not follow standard SAS naming conventions.




    en

    Problem Notes for SAS®9 - 65295: The order of columns is not maintained when you select columns for output in the Business Rules transformation

    In SAS Data Integration Studio, the columns that you select to include in the target table in a Business Rules transformation appear in the Selected columns area in a random order. Th




    en

    Problem Notes for SAS®9 - 65916: Accessing a Google BigQuery table without including the SCHEMA= option in the LIBNAME statement might result in an error

    When you issue a LIBNAME statement for a Google BigQuery database without including the SCHEMA= option, all tables in the project are shown when the libref is expanded. However, if you try to acces




    en

    Problem Notes for SAS®9 - 65935: The UNICODE function does not support Numeric Character Representation (NCR) for a surrogate pair

    Using the NCR form of a surrogate pair as an input string to the UNICODE function does not convert the string to the appropriate display character.




    en

    Problem Notes for SAS®9 - 34294: A missing discrete dependent variable in the selection model together with a OUTPUT statement might cause an Access Violation error

    If the following conditions are met in PROC QLIM: the SELECT option and DISCRETE option are specified in the same MODEL statement or ENDOGENOUS statement the same dependent variable with S




    en

    Problem Notes for SAS®9 - 65927: The Copy Files task in SAS Enterprise Guide 8.2 fails with the message "ERROR: Target folder does not exist or cannot be accessed"

    When you run the Copy Files task in SAS Enterprise Guide and there is no connection to a SAS server, it fails with the following error: "ERROR: Target folder does not exist or cannot be accessed."




    en

    Problem Notes for SAS®9 - 65903: You see a "java.lang.IllegalArgumentException" error in the log file when you use the IFRS9_Cycle workflow template in SAS Solution for IFRS 9

    The problem occurs on a content release on the SAS Risk Governance Framework.




    en

    Problem Notes for SAS®9 - 65872: You see a "java.lang.IllegalArgumentException" error in the log file when you use the CECL_Cycle workflow template in SAS Solution for CECL

    The problem occurs on a content release on the SAS Risk Governance Framework.




    en

    Problem Notes for SAS®9 - 65904: SAS Federation Server stops responding when you run queries against X_OBJECT_PRIVILEGES in SYSCAT and the queries run for hours

    The select * from "SYSCAT"."SYSCAT"."X_EFFECTIVE_OBJECT_PRIVILEGES" query runs for hours. In this scenario, SAS Federation Server stops responding, making it unavailable for use. Restarting SAS Federation Server solves t




    en

    Problem Notes for SAS®9 - 65682: Running FedSQL with an Oracle table is slow, even when you use a LIMIT clause

    When you query an Oracle table and use the LIMIT clause using either SAS  Federation Server or FedSQL, a row limit is not passed to the database. In this scenario, a Full Article



    en

    Problem Notes for SAS®9 - 65914: You see the error "Driver does not support this optional feature" after trying to insert or append data to a Databricks table

    You can create create a Databricks table by using PROC SQL, but you cannot insert data into the table. PROC APPEND cannot create a new table or append data to an existing table.




    en

    Problem Notes for SAS®9 - 65898: A misleading SASTRACE message appears in the log when you insert a row into an Oracle table using SAS/ACCESS Interface to Oracle with DBIDIRECTEXEC

    When you add one row to an Oracle table using DBIDIRECTEXEC, you see the following misleading trace message: "ORACLE: 4294967296 rows inserted/updated/deleted." You should see something similar to the following: "ORACLE: 1 rows inserte




    en

    Problem Notes for SAS®9 - 65909: SAS Visual Analytics Designer 7.5 responds slowly when you edit large or complex reports

    If your SAS Visual Analytics report contains many sections and objects, you might encounter performance problems when you are editing the report.   A hot fix is planned for this issue.




    en

    Problem Notes for SAS®9 - 64550: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter

    Severity: Medium Description: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter. Potential Impact:




    en

    Problem Notes for SAS®9 - 65893: Custom sorts are sorted incorrectly when they are used in a hierarchy in SAS Visual Analytics Designer

    A custom sort might be sorted incorrectly when the data item is used in a custom category, which is then used in a hierarchy. The issue can occur in the following scenario:




    en

    Problem Notes for SAS®9 - 65835: A series of PROC SQL queries might not generate a distinct set of rows

    A set of PROC SQL queries that create a view, contain a constant column, contain a computed column, and a create a table do not generate a unique set of rows in the table that is created.




    en

    Problem Notes for SAS®9 - 65572: The length of a string variable might be longer than specified with the MAX_CHAR_LEN= option

    When you read in a BigQuery table, the length of string variables might be longer than the length specified with the MAX_CHAR_LEN= option when running your SAS software   with UTF-8. By




    en

    Problem Notes for SAS®9 - 65883: SAS Workflow Studio returns a "cannot load" error when you try to open the CECL_Cycle_AFS workflow template for SAS Solution for CECL

    You might see the following error in SAS Workflow Studio when you try to open the CECL_Cycle_AFS workflow template that is shipped with SAS Solution for CECL:



    en

    Problem Notes for SAS®9 - 65856: The process of updating a lookup table in SAS Business Rules Manager (running in UNIX operating environments) does not work properly

    Under UNIX, the process of updating a lookup table in SAS Business Rules Manager does not work properly. The problem occurs when you perform these steps:  Open a lookup table. Cl




    en

    Problem Notes for SAS®9 - 65869: SAS Visual Data Builder does not enable you to schedule with multiple time-event triggers

    SAS Visual Data Builder might not enable you to create multiple time-event triggers. The + button to add another trigger is not available to select, as shown in the following display: imgalt="" src="{fusion_658




    en

    Inbox: How will potential new rule affect Rays?

    Rays beat reporter Juan Toribio answers fans' questions.




    en

    Predicting Rays' Opening Day roster

    Here's an early look at how the Rays' 25-man roster could shape up on Opening Day.




    en

    Faria enters camp fighting for bullpen spot

    After a disappointing 2018 season, Jake Faria is looking to show that last season isn't reflective of the type of pitcher he is.




    en

    Glasnow working to quicken delivery

    Tyler Glasnow is hoping to build off a positive 2018, but his delivery is going to look a little different this season.




    en

    Diaz aims to turn heads, cement everyday role

    When Yandy Diaz arrived at Rays camp on Sunday, he quickly established himself as the most muscular player inside the clubhouse. During Spring Training, his focus will be to establish himself as an everyday player.




    en

    Management of severe acute pancreatitis




    en

    Cognitive symptoms of Alzheimer’s disease: clinical management and prevention




    en

    Does general anesthesia affect neurodevelopment in infants and children?




    en

    Thyroid nodules: diagnostic evaluation based on thyroid cancer risk assessment




    en

    Linking risk factors and outcomes in autism spectrum disorder: is there evidence for resilience?




    en

    Management of acute ischemic stroke




    en

    Current and future treatments for tuberculosis




    en

    Management of ANCA associated vasculitis




    en

    Autoimmune complications of immunotherapy: pathophysiology and management




    en

    Advances in regenerative medicine for otolaryngology/head and neck surgery




    en

    ER stress increases store-operated Ca2+ entry (SOCE) and augments basal insulin secretion in pancreatic beta cells [Molecular Bases of Disease]

    Type 2 diabetes mellitus (T2DM) is characterized by impaired glucose-stimulated insulin secretion and increased peripheral insulin resistance. Unremitting endoplasmic reticulum (ER) stress can lead to beta-cell apoptosis and has been linked to type 2 diabetes. Although many studies have attempted to link ER stress and T2DM, the specific effects of ER stress on beta-cell function remain incompletely understood. To determine the interrelationship between ER stress and beta-cell function, here we treated insulin-secreting INS-1(832/13) cells or isolated mouse islets with the ER stress–inducer tunicamycin (TM). TM induced ER stress as expected, as evidenced by activation of the unfolded protein response. Beta cells treated with TM also exhibited concomitant alterations in their electrical activity and cytosolic free Ca2+ oscillations. As ER stress is known to reduce ER Ca2+ levels, we tested the hypothesis that the observed increase in Ca2+ oscillations occurred because of reduced ER Ca2+ levels and, in turn, increased store-operated Ca2+ entry. TM-induced cytosolic Ca2+ and membrane electrical oscillations were acutely inhibited by YM58483, which blocks store-operated Ca2+ channels. Significantly, TM-treated cells secreted increased insulin under conditions normally associated with only minimal release, e.g. 5 mm glucose, and YM58483 blocked this secretion. Taken together, these results support a critical role for ER Ca2+ depletion–activated Ca2+ current in mediating Ca2+-induced insulin secretion in response to ER stress.




    en

    Detailed analyses of the crucial functions of Zn transporter proteins in alkaline phosphatase activation [Enzymology]

    Numerous zinc ectoenzymes are metalated by zinc and activated in the compartments of the early secretory pathway before reaching their destination. Zn transporter (ZNT) proteins located in these compartments are essential for ectoenzyme activation. We have previously reported that ZNT proteins, specifically ZNT5–ZNT6 heterodimers and ZNT7 homodimers, play critical roles in the activation of zinc ectoenzymes, such as alkaline phosphatases (ALPs), by mobilizing cytosolic zinc into these compartments. However, this process remains incompletely understood. Here, using genetically-engineered chicken DT40 cells, we first determined that Zrt/Irt-like protein (ZIP) transporters that are localized to the compartments of the early secretory pathway play only a minor role in the ALP activation process. These transporters included ZIP7, ZIP9, and ZIP13, performing pivotal functions in maintaining cellular homeostasis by effluxing zinc out of the compartments. Next, using purified ALP proteins, we showed that zinc metalation on ALP produced in DT40 cells lacking ZNT5–ZNT6 heterodimers and ZNT7 homodimers is impaired. Finally, by genetically disrupting both ZNT5 and ZNT7 in human HAP1 cells, we directly demonstrated that the tissue-nonspecific ALP-activating functions of both ZNT complexes are conserved in human cells. Furthermore, using mutant HAP1 cells, we uncovered a previously-unrecognized and unique spatial regulation of ZNT5–ZNT6 heterodimer formation, wherein ZNT5 recruits ZNT6 to the Golgi apparatus to form the heterodimeric complex. These findings fill in major gaps in our understanding of the molecular mechanisms underlying zinc ectoenzyme activation in the compartments of the early secretory pathway.




    en

    Delineating an extracellular redox-sensitive module in T-type Ca2+ channels [Membrane Biology]

    T-type (Cav3) Ca2+ channels are important regulators of excitability and rhythmic activity of excitable cells. Among other voltage-gated Ca2+ channels, Cav3 channels are uniquely sensitive to oxidation and zinc. Using recombinant protein expression in HEK293 cells, patch clamp electrophysiology, site-directed mutagenesis, and homology modeling, we report here that modulation of Cav3.2 by redox agents and zinc is mediated by a unique extracellular module containing a high-affinity metal-binding site formed by the extracellular IS1–IS2 and IS3–IS4 loops of domain I and a cluster of extracellular cysteines in the IS1–IS2 loop. Patch clamp recording of recombinant Cav3.2 currents revealed that two cysteine-modifying agents, sodium (2-sulfonatoethyl) methanethiosulfonate (MTSES) and N-ethylmaleimide, as well as a reactive oxygen species–producing neuropeptide, substance P (SP), inhibit Cav3.2 current to similar degrees and that this inhibition is reversed by a reducing agent and a zinc chelator. Pre-application of MTSES prevented further SP-mediated current inhibition. Substitution of the zinc-binding residue His191 in Cav3.2 reduced the channel's sensitivity to MTSES, and introduction of the corresponding histidine into Cav3.1 sensitized it to MTSES. Removal of extracellular cysteines from the IS1–IS2 loop of Cav3.2 reduced its sensitivity to MTSES and SP. We hypothesize that oxidative modification of IS1–IS2 loop cysteines induces allosteric changes in the zinc-binding site of Cav3.2 so that it becomes sensitive to ambient zinc.




    en

    ADAM10 and ADAM17 proteases mediate proinflammatory cytokine-induced and constitutive cleavage of endomucin from the endothelial surface [Membrane Biology]

    Contact between inflammatory cells and endothelial cells (ECs) is a crucial step in vascular inflammation. Recently, we demonstrated that the cell-surface level of endomucin (EMCN), a heavily O-glycosylated single-transmembrane sialomucin, interferes with the interactions between inflammatory cells and ECs. We have also shown that, in response to an inflammatory stimulus, EMCN is cleared from the cell surface by an unknown mechanism. In this study, using adenovirus-mediated overexpression of a tagged EMCN in human umbilical vein ECs, we found that treatment with tumor necrosis factor α (TNF-α) or the strong oxidant pervanadate leads to loss of cell-surface EMCN and increases the levels of the C-terminal fragment of EMCN 3- to 4-fold. Furthermore, treatment with the broad-spectrum matrix metalloproteinase inhibitor batimastat (BB94) or inhibition of ADAM metallopeptidase domain 10 (ADAM10) and ADAM17 with two small-molecule inhibitors, GW280264X and GI254023X, or with siRNA significantly reduced basal and TNFα-induced cell-surface EMCN cleavage. Release of the C-terminal fragment of EMCN by TNF-α treatment was blocked by chemical inhibition of ADAM10 alone or in combination with ADAM17. These results indicate that cell-surface EMCN undergoes constitutive cleavage and that TNF-α treatment dramatically increases this cleavage, which is mediated predominantly by ADAM10 and ADAM17. As endothelial cell-surface EMCN attenuates leukocyte–EC interactions during inflammation, we propose that EMCN is a potential therapeutic target to manage vascular inflammation.




    en

    Overexpression of GPR40 in Pancreatic {beta}-Cells Augments Glucose Stimulated Insulin Secretion and Improves Glucose Tolerance in Normal and Diabetic Mice

    Objective:

    GPR40 is a G protein-coupled receptor regulating free fatty acid-induced insulin secretion. We have generated transgenic mice overexpressing the human GPR40 gene (hGPR40-Tg) under control of the mouse insulin II promoter and have used them to examine the role of GPR40 in the regulation of insulin secretion and glucose homeostasis.

    Research Design and Methods:

    Normal (C57BL/6J) and diabetic (KK) mice overexpressing the human GPR40 gene under control of the insulin II promoter were generated, and their glucose metabolism and islet function were analyzed.

    Results:

    In comparison with nontransgenic littermates, hGPR40-Tg mice exhibited improved oral glucose tolerance with an increase in insulin secretion. Although islet morphological analysis showed no obvious differences between hGPR40-Tg and nontransgenic (NonTg) mice, isolated islets from hGPR40-Tg mice enhanced insulin secretion in response to high glucose (16 mM) than those from NonTg mice with unchanged low glucose (3 mM)-stimulated insulin secretion. In addition, hGPR40-Tg islets significantly increased insulin secretion against a naturally occurring agonist palmitate in the presence of 11 mM glucose. hGPR40-Tg mice were also found to be resistant to high fat diet-induced glucose intolerance, and hGPR40-Tg harboring KK mice showed augmented insulin secretion and improved oral glucose tolerance compared to nontransgenic littermates.

    Conclusions:

    Our results suggest that GPR40 may have a role in regulating glucose-stimulated insulin secretion and plasma glucose levels in vivo, and that pharmacological activation of GPR40 may provide a novel insulin secretagogue beneficial for the treatment of type 2 diabetes.




    en

    A Peripheral Blood DNA Methylation Signature of Hepatic Fat Reveals a Potential Causal Pathway for Nonalcoholic Fatty Liver Disease

    Nonalcoholic fatty liver disease (NAFLD) is a risk factor for type 2 diabetes (T2D). We aimed to identify the peripheral blood DNA methylation signature of hepatic fat. We conducted epigenome-wide association studies of hepatic fat in 3,400 European ancestry (EA) participants and in 401 Hispanic ancestry and 724 African ancestry participants from four population-based cohort studies. Hepatic fat was measured using computed tomography or ultrasound imaging and DNA methylation was assessed at >400,000 cytosine-guanine dinucleotides (CpGs) in whole blood or CD14+ monocytes using a commercial array. We identified 22 CpGs associated with hepatic fat in EA participants at a false discovery rate <0.05 (corresponding P = 6.9 x 10–6) with replication at Bonferroni-corrected P < 8.6 x 10–4. Mendelian randomization analyses supported the association of hypomethylation of cg08309687 (LINC00649) with NAFLD (P = 2.5 x 10–4). Hypomethylation of the same CpG was also associated with risk for new-onset T2D (P = 0.005). Our study demonstrates that a peripheral blood–derived DNA methylation signature is robustly associated with hepatic fat accumulation. The hepatic fat–associated CpGs may represent attractive biomarkers for T2D. Future studies are warranted to explore mechanisms and to examine DNA methylation signatures of NAFLD across racial/ethnic groups.